cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

IBP calculate avg price and copy to another planning level

OliverA41
Active Participant
0 Kudos
440

Hello,

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.

View Entire Topic
OliverA41
Active Participant
0 Kudos

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.

Regards

Oliver