How to apply the pervious quarter average to current quarter months?

Shisong

Hi

Is it possible to do the following calculation?

The average of market price of the previous quarter will be set as agreed price of each month of current quarter.

Remo Bollhalder

Hi @Shisong

an easy way would be to:

• set the total by quarter
• period offset of -3
• divide by number of months (3)

I am sure there are other ways to calculate the average but that should work as a quick implementation.

Best

Remo

Shisong

Thanks. @Remo Bollhalder
That works like a charm.