Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I need to achieve below :-
1) YOY and MOM
2) Show these values in KPI and up and down arrows like below :-
I am able to calculate YOY but facing issue in MOM. PFB the expression :-
=(Sum({<Month=, Date=, Brand ={'Plusnet'},MonthName={'$(=MaxString(MonthName))'}>} Value)
-
Sum({<Brand ={'Plusnet'},Month=, Date=, MonthName={'$(=(MaxString(MonthName) -1))'}>} Value))
/
Sum({<Brand ={'Plusnet'},Month=, Date=, MonthName={'$(=MaxString(MonthName))'}>} Value)
This expression gives me in correct result and when I checked the variable values ,I found that for max month it is showing Apr-2022 but for previous month (i.e max(month)-1) gives me month in number format. Here are my fields:-
Can anyone please help ?
Thanks in advance
MaxString(MonthName)-1 is not "The month before the current month". It is the last day of the month previous to MonthName (the first of the month minus one day).
Try using AddMonths(MonthName,-1) instead, or applying MonthName(MonthName-1).