Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I want to know how to write set analysis for like we are in feb 2023, so need to show what is the sales for lastmonth like jan sales and 3rd month like november 2022 and sept2022 sales
form current month to 1st, 3rd, 6th month like this
If there are fields (example 1MonthField) to flag (1 true) for the period in the mastercalendar:
sum({< 1MonthField = {1}>} *formula*)
...
For last 1 month : Sum({<Month={"Month(AddMonths(Today(),-1))"}>}Sales)
For 3rd month : Sum({<Month={"Month(AddMonths(Today(),-3))"}>}Sales)
For 6th month : Sum({<Month={"Month(AddMonths(Today(),-6))"}>}Sales)