Forum Discussion
Inflation accumulation
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?
2 Replies
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 (minceddata.info)
In this article, I describe how table iterators can be used to calculate accumulative percentages.Hopefully, this helps to tackle your challenge.
Regards,
Tom
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.
