6 Months Avarage in separate key figure

[Former Member]

Hi IBP colleagues,

Can you please suggest, how to build following customer requirement:

Let's say we have a key figure with Actuals,

Then we need to have another one which should calculate avarage actuals value for past 6 months and show this value for current month.

Also this value will be used in another calculations within this Planning Area.

I know that I can use avarage statistical model but it would be better if it will be possible to achieve this via configuration.

Can you please suggest, how to build this?

Thanks, Andrey.

[achal_gautam2]

Hi Andrey,

Yes, its possible to calculate 6 months Average via calculation. This post is very useful and I have configured the average of 6 monthslike this and it works.