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

Shisong
Shisong Active Partner, Community Captain
5 Answers 10 Comments September Badge of the Month Photogenic
in Platform

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.

image.png

Accepted Answer

  • Remo Bollhalder
    Remo Bollhalder Employee
    Third Anniversary 5 Answers 10 Comments 5 Up Votes
    Answer ✓

    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.

    image.png

    Best

    Remo

Answers

Categories