4 Replies Latest reply on Nov 12, 2018 4:43 AM by madhuri.tanniru

    Show missing values and table calculations

    madhuri.tanniru

      Hi,

       

      I am trying to compare price quoted on this day to the date exactly last year  [ 2016-01-30  vs  2017-01-30]

       

      However, my data doesn't have all of the dates to use lookup function (365 days) to get to the next years date.

       

      Also, I will have to consider the date Feb 29 and it shouldn't have corresponding price from the next years date.

       

      Please find the attached,

       

      Thanks