Previous Month Value

[zahidrahim_ocp]

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

[ramcena306]

Hi, may be like this,

sum({<MonthYear={">=$(=Date(addmonths(Max(MonthYear),-1),'MMM-YY'))"}>}SalesAmount)

[Anonymous]

Pradosh,

thanks!!! This one worked for me too. Great!

Gilbert