20 Replies Latest reply: Dec 30, 2017 5:29 AM by ramesh g RSS

    Previous Month Value

    zahid Rahim

      Dear Experts,

       

      I have a period filter with JAN-17-----DEC-17 periods. I want if user select DEC-17 I can show him previous month figures as well. For this purpose i have obtained previous month using:

      Upper(date(ADDMONTHS(date#((STOCK_PERIOD),'MMM-YY'),-1),'MMM-YY')))

       

      Now i want to write a set expression to get the value but i am keep getting 0

       

      Sum({<STOCK_PERIOD = {"'$(='=' & Upper(date(ADDMONTHS(date#((STOCK_PERIOD),'MMM-YY'),-1),'MMM-YY')))'"}>} (PRIMARY_QUANTITY*CMPNT_COST))

       

      Please help.

       

      Regards,

       

      Zahid Rahim