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

[deveshbohre]

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

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 ?

[Praveen_Jadhav · Accepted solution]

Hi daeboo183

You can create a new KF "Avg History" using the IBP function: IBP_RAGGR. From the example given by you, the parameters which can be used are:

Input key figure = History

Aggregation mode = AVG

Start rolling agg = -100 (Assuming root time period is month, else change this value accordingly)

Duration of rolling agg. = 200 (Assuming root time period is month, else change this value accordingly)

Horizon = PASTCURRENT

Restart at = (Not provided)

For more details, refer:

https://help.sap.com/docs/SAP_INTEGRATED_BUSINESS_PLANNING/bf99e931b8d44aafb4e306ec3602cbdd/32b980b1...

BR,

Praveen Jadhav

[deveshbohre · Accepted solution]

Thanks Praveen , but somehow its showing no result

KF2@BPL= IBP_RAGGR ("KF1@BPL (Stored KF)",''AVG'', -100,200,''PASTCURRENT'')

[Praveen_Jadhav · Accepted solution]

Could you share the snapshot for both the KFs?

The above logic should work, mostly it may be issue with request level calculation.

[deveshbohre · Accepted solution]

Apologies for late response,

it was some test system data issue, layer i cleared cache as well and cleanup the data, its working fine , Thanks Praveen .

[deveshbohre · Accepted solution]

only change I made is kept the calculation limited to past using ''PAST'' and not ' ' PASTCURENT' '