Creating iterations in Anaplan

JR1010

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!

shubhamrawat

Hi @JR1010

You can make use of Previous() function, use below code to implement this.

SriNitya

JR1010

Hi instead of multiplying 90% in formula store in line item and refer it, it is the best way to do and is mentioned in Planual.

Kanishq17

Hey , you can use previous() to achieve the functionality

Dikshant

https://community.anaplan.com/discussion/51140/performance-comparison-offset-lag-previous-lookup

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 😉