Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
In the YearMonth Field I have records from 2017/01 to 2018/02.
Here I have to restrict last 12 months
Sum({<YearMonth={">=$(=Max(YearMonth)-12) <$(=Max(YearMonth))"}>}Sales)
with the above expression when I have selected 2018/01 then getting last 12 months from 2017/01 to 2017/12
but when i have selected 2018/02 then getting last 13 months from 2018/01 to 2017/01 but need to get 2018/01 to 2017/02.
How to get this. Please help me on it. Please find the attached Document.
Thanks in advance
It's not taking into consideration the >=$(=Max(YearMonth)-12) part
change ur expression as follow:
=Sum({<YearMonth={">=$(=date(addMonths(Max(YearMonth),-12),'YYYY/MM')) <$(=Max(YearMonth))"}>}Sales)
result:
see the attached app:
It's not taking into consideration the >=$(=Max(YearMonth)-12) part
change ur expression as follow:
=Sum({<YearMonth={">=$(=date(addMonths(Max(YearMonth),-12),'YYYY/MM')) <$(=Max(YearMonth))"}>}Sales)
result:
see the attached app:
Sum({<YearMonth={">$(=Max(YearMonth)-12) <$(=Max(YearMonth))"}>}Sales)
No, that won't do it Jonathan;
in fact, in this case:
=date(Max(YearMonth)-12,'YYYY/MM') would go back by 12 days: