8 Replies Latest reply: May 31, 2018 7:05 AM by Sunny Talwar RSS

    Previous Date Calculation

    Akpofure Enughwure

      Hello everyone,


      I got this table where I need to compare current date (max date = 20/02/2018) and previous date ( 19/02/2018)


      I tried using


      Sum({<Date= {"$(=Max(Date))"}>} [Partner Closing Stock]) -------- Correct


      Sum({<Date= {"$(=Max(Date) -1)"}>} [Partner Closing Stock])  ------- not giving me the right answer

      Can you help me?

      Thank you