Forecasting using inflation rates

[Former Member]

Hi

I have a requirement to generate the forecast by applying inflation rates. Planning will be done on rolling 24 months and then these should be projected to long terms plan (5 year rolling) based on inflation rates.

My initial thought is using script logic copy the 24 months forecast to remaining 36 months and then multiply with the inflation rates. But this calculation is not very straight forward, because rate should be applied to value in previous periods.

For example

Can you please share your thoughts ?

Version is

BPC 10.1 Standard

Thank you very much.

Sincerely,

Ram

[former_member186338]

Sorry, but the calculation logic is not clear! What values do you want to adjust using inflation rates?

[former_member186338]

There is no standard way and my formula will provide the correct result! Just try to understand the logic of my formula.

P.S. And please!!!! Read https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/