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