Creating iterations in Anaplan
Hey Everyone,
I'm trying to find a solution in an excel sheet that utilizes an iteration function that I need to replicate in Anaplan. Basically, we take the previous number multiply it by 90%, then take that new number and multiply it again by 90%. For example,
FY2024 is 28,940
FY2025 is 26,046
FY2026 is 23,441 (etc etc etc).
I've tried a few ideas (utilizing POST/OFFSET & trying DECUMULATE) but haven't had much luck. Any advice would be much appreciated!
Best Answer
-
Hi @JR1010
You can make use of Previous() function, use below code to implement this.
1
Answers
-
Hey , you can use previous() to achieve the functionality
0 -
I would recommend everyone to go through article as it shared detailed information on the performance of all these functions, like OFFSET, POST, LOOKUP.
Note: Don't worry, Previous function performs way better 😉
0