Skip to Content
avatar image
Former Member

Sum/average the past 6 periods in IBP

Hi,

We have the business requirement to create a bias tracking signal report that has a rolling total forecast variance (fcst-actuals) sum over the past 6 periods (including the current period) and the sum of the absolute value of the past 6 periods. Then calculate the absolute sum of the past 6 periods divided by 6 to get a MAD. The final result is the total forecast variance (without absolute) / MAD. We have referenced the link below for this situation however, we believe it will probably require L code script for us to go that route with periodid transformation for calculating the 6 past periods. Please advise if anyone has found a way to calculate this without using L code. Maybe local member if there's example for this situation or if the periodid transformation can work would be possibilities.

https://answers.sap.com/questions/132108/past-6-weeks-average-sap-ibp.html

Thanks,

Melanie

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 04, 2017 at 12:36 PM

    Hello Sanjeev,

    Have you also checked Note 2240170? It has a PDF SAP Integrated Business Planning Advanced Configuration - Rolling Sum of Last Three Periods (Attribute Transformation).pdf attached that explains how to configure a Key Figure with sum from the last three periods (starting from the current period) on a rolling basis. You may just change the SUM by the AVG, in this case.

    Best regards,
    Matheus

    Add comment
    10|10000 characters needed characters exceeded