Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)