21 Replies Latest reply: Feb 14, 2018 1:42 PM by Gilbert Linsen 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:



      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.




      Zahid Rahim