Summary Method Problem
Hi all I'm having some weird numbers on month over month rate calculation that I did. I tried to use Formula for the summary method but it throws me this error below:
I'm not sure if the issue lies in the formula or the summary method. With calculations like this using PREVIOUS() what is the best summary method to use.
Best Answer

Hi @innocent,
What is the "Revenue Per Day Acts" data type?
If it is not a %, then, here, numbers and % are mixed in the same formula. In other words, the amount after the 3rd "THEN" (the pink one) is not a % but a "regular number" while the results after the "ELSE" are %.
Depending on the business logic behind, changing to PREVIOUS(Change MoM) after the 2nd "THEN" could be an idea.
By the way, some tips to improve the performance:
 the same PREVIOUS calculation is done 5 times which makes Anaplan do the calculation 5 times. Instead, you could have a separate line item with the PREVIOUS formula and reference it in Change MoM
 it seems that the results after the 2nd and the 3rd "ELSE" are the same so you should be able to remove an IF statement if you play with the conditions
 "SUM" Summary is usually not the best summary method for % but it depends on the business logic
 you cannot use Formula summary with Previous function, good workaround explained here:
Hope this helps!
0
Answers

Thanks @BenjaminNiel the post was very helpful.
1