Previous month value

[zahidrahim_ocp]

Dear Experts,

I have monthwise data where i can see figures for the selected month now i want to see the value of the previous month from the selected month. i am using below expression but in vain.

My filter and month date is in MNTH_DATE column.

Sum({<Date(MNTH_DATE)={"$(=Date(AddMonths(vDate, -1)))"}>}  ORDERED_QUANTITY_VOL)

Regards,

Zahid Rahim

stalwar1‌

[sunny_talwar]

You are not allowed to use functions on the left hand side of your set modifier....

Why are you using Date() here? Is your MNTH_DATE a timestamp? or are you trying to format it in a certain way... I would do this

Sum({<MNTH_DATE = {"$(=Date(AddMonths(vDate, -1), 'DateFieldFormatHere'))"}>}  ORDERED_QUANTITY_VOL)