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

    Show missing values and table calculations




      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,