IBP max Value in KF calculation

[OliverA41]

Hi,

i have a demand kf with follow kf values per period

100 200 300 100

now I want in a second kf the highest value in this example 300

with the max calculation I cannot find the max value about 4 periods.

How can I do this

Regards

Oliver

[OliverA41]

how I can get the highest value of a time series in another kf

[AyanBishnu]

Hello ori

In order to get the desired output use the below expression. for example the KF where you have values is KF1 and the output KF will be KF2 and planning level is MTHPRODLOCCUST

KF2@MTHPRODLOCCUST = IBP_RAGGR ("KF1@MTHPRODLOCCUST", ''MAX'', 0, 4, ''CURRENTFUTURE'')

[former_member804657]

Hi Oliver,

You can use the rolling aggregation with the MAX aggregation type in another calculated key figure for the rolling past 4 periods.

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

Hope this helps

Sittinut