Skip to Content
0
Jul 20, 2020 at 10:39 AM

IBP calculate avg price and copy to another planning level

87 Views

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.

Attachments