4 Replies Latest reply: Feb 8, 2016 11:19 AM by Onno van Knotsenburg RSS

    Year on Year Analysis on given Dates

      Hi, requesting assistance on the proper expression to be written for a chart, and possibly a line graph. I basically need to compare each date with the stock's price from the exact date 1 year ago. Yet if data for the previous year is not available (or if it is available but appears recorded as 0), then the expression should refer to the stock price of the latest date with available data.

       

      For example, there are 2 columns, Date and Price, with the following sample data and needed expression result. Thanks!

       

      DatePriceExpression Result
      2/7/2016239.28206.32
      2/6/2016239.15206.09
      2/5/2016239.11206.09
      2/7/2015206.32---
      2/6/20150---
      2/5/2015206.09---