4 Replies Latest reply on Jun 14, 2017 8:02 PM by Chris McClellan

    LY calculation

    Chris McClellan

      I know I'm going to kick myself when I find out the answer, because I've done this plenty of times previously and I just can't think of the answer now ...

       

      Using the TWB file and the XLS file, I want the user to choose a date in 2017 and get the value for that date and the corresponding value from the same date last year.

       

      I know I can do it by duplicating the data source, but for simplicity I want to use the datasource once and create a calculated field that displays the value from last year.