5 Replies Latest reply: Sep 19, 2014 5:42 AM by jagan mohan rao appala RSS

    addmonths() not working in my set analysis

      Hi,

      I am trying to get previous month sales, but seems addmonths() is not working in my expression, it always return the current month's sales, can anyone help debug?

      =sum({$<Period_ID = {"=$(=MonthEnd(AddMonths(max(Period_ID),-1)))"}>} Sales)

      my Period_ID is the month end date in my date

       

      Thanks,

      XX