Skip to Content

IBP calculate avg price and copy to another planning level


I need a process of follow calculation

I have the planned price from Jul 2019 until Jul 2020. for this period, I need the avg. price. After that, the average price must be copy from the planning level month to year level. The reason is, to calculate the next year with the average price form last year.

the example in the screenshot is create with an excel formular.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 21, 2020 at 05:13 AM


    Do you need this calculation every time Jul 20** to Jul** or any other conditions?

    A simple way is to calculate the average price run the statistical forecast for the requirement horizon and then create a new key figure copy the average price in to custom key figure.

    Best Regards,


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 21, 2020 at 07:23 AM

    Hi Lingaiah,

    yes you are absolute right and I had to smile about the ease with which it could be done. :-) Great.

    For your question. Yes it can be different conditions.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.