Quick question:
I trying to aggregate sales from the last 3 months based off my parameter, Reference Date. Can someone point me in the right direction with this?
I tried using the following calculated field, however it only returns sales for one month.
DATEDIFF('month',[Month-Year],[Reference Date])= 3
5 answers
Do you want to do calculation 3 months prior to current Month (FEB)? Then follow Jhansi Formula.
IF you want to do calculation not with respect to Current month,
DATEDIFF('month',[Month-Year],[Reference Date]) >=0 and DATEDIFF('month',[Month-Year],[Reference Date]) <=3
