Skip to Content
0
Nov 15, 2022 at 02:04 PM

How to calculate average of Actual History and display in past horizon?

273 Views

Hello Experts,

I have a business requirement where user wanted the past 12 month/24 months sales history average to be displayed in past horizon

image.png

as a workaround I created a forecast model with simple average algorithm and capture the value in M1 month. but this required running for stat fcst.

Do we have any IBP Function or any other more suitable option for this ?

Attachments

image.png (9.0 kB)
image.png (9.4 kB)