Calculation of SImple Average for same periods

[victor_hugodebastosleo]

Hi Experts!

I would like to calculate the simple average of all defined months of the past years.

Example:

Actuals for August 2020 = 30

Actuals for September 2020 = 60

Actuals for October 2020 = 100

Actuals for August 2021 = 20

Actuals for September 2021 = 40

Actuals for September 2021 = 80

Actuals for August 2022 = 40

Actuals for September 2022 = 80

Actuals for October 2022 = 120

So...

For August, (30 + 20 + 40) / 3 = 30

For September, (60 + 40 + 80) / 3 = 60

For October, (100 + 80 + 120) / 3 = 100

And so on…

Do you see any way to calculate it as described above?

Thanks a lot!

Best regards!

Victor

[Irmi_Kuntze]

Hi Victor

Just as a thought: You might create 3 new KF using simplified operator IBP_PERIODSHIFT (check model configuration guide) of 12 months, 24 months, and 36 months respectively, in which you copy the actuals, so you have 3 Input KF for your average calculation

- Actuals, with "August" of last year (2022) = 40

- Actuals, with "August" of last year -1 (2021) = 20

- Actuals, with "August" of last year -2 (2020) = 30

Than you just add up month by month the three KF and divide by 3.

Yours

Irmi