Creating iterations in Anaplan

edited June 20 in Academy Discussions

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