18 Replies Latest reply: Dec 27, 2016 4:11 AM by Hirish V RSS

    Calculating previous week value

    Ishan Bansal

      Hi All,


      I have a weekend date as my filter option. As we follow different calendar so we have a different weekend dates.


      Weekend date is the filter option.


      I am calculating week on week where current week value is sum(sales)

      the previous week formula that i have written is

      SUM({<WEEKEND_DATE = {'$(=MAX(WEEKEND_DATE-7))'}>} sales)


      but after many try and attempts of doing this i am getting the value as 0 always. Please suggest.


      Note : Weekend date is difference of 7 days