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

    Date Issues

    Fernando Urbina

      Hi,

       

        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:

       

         Date

         Sales_Amount

         Store_Id

         Equivalent_date

       

      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.