This content has been marked as final.
Show 3 replies
-
Re: Last 12 months restriction
omar bensalem Feb 5, 2018 7:08 AM (in response to bhavani b)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:
-
Month-Sort App.qvf 208.0 K
-
-
Re: Last 12 months restriction
Jonathan Dienst Feb 5, 2018 7:10 AM (in response to bhavani b)Sum({<YearMonth={">$(=Max(YearMonth)-12) <$(=Max(YearMonth))"}>}Sales)
-