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