Inflation accumulation

[yerzhan_go]

Hello guys!

I need your help. I need to enter this inlflation table to my calculator bi project, but i dont know how to do that.

Inflation 2,5% must be changeble with paramater what-if, it means if you change to 5%(8%,10% and other), then accumulation will be: 
2020 year 100% (because its a starter year)
2021 year 105%

2022 year 110,25% 

How to do that?

[Anonymous]

Hi @yerzhan_go 

I don’t quit understand the operational logic for the data you provide .

From 2021 to 2020 , the value of accumulation increased by 2.5 % , the value for 2021 is 102.5% ,it is normally .But for 2022, the value for accumulation is 105.06% , the diff is 2.56%.And all the diff next is not 2.5% .

So I am a bit confused, what are your calculation rules ? Can you provide your calculation rules and expected results ?

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TomMartens]

Hey @yerzhan_go ,

please allow me to direct your attention to an article of mine: Using Table Iterators to calculate a future value - Mincing Data - Gain Insight from Data (minceddat...
In this article, I describe how table iterators can be used to calculate accumulative percentages.

Hopefully, this helps to tackle your challenge.

Regards,

Tom