4 Replies Latest reply: Apr 28, 2014 5:26 AM by Murti Akkime RSS

    Date Issues



        Here is my problem, i have a sales table that started last year, and i want to compare sales from this year with the year before in two ways, the first like going exactly 365 days back and the other pointing to a specific date in the past, The table goes like this:







      The last field would be the equivalent day to compare (to solve issues arround feb 29 or special day sales).


      Im trying something like:


      =sum({$<Equivalent_date={"=$(Date)"}, Date=>} Sales_Amount)


      It just dont work


      Thx in advance.