4 Quarter Average for a year

Saisri8568 · June 2022

How to get 4 quarter average of the same year for all quarters in a separate line item(Quarter formatted)

Thanks.

Akhtar.shahbaz · June 2022

Hi

We can calculate in many ways but recommended & easy with the summary method

below is another way of doing but required some mapping as shown Qty 2.png

QTY 3.png

whitby · June 2022

Of course - I'm forgetting your video 😅 https://youtu.be/PvimWuX5jVw

whitby · June 2022

hi @Saisri8568 - try using YEARVALUE(a).

Saisri8568 · June 2022

Thank you. But, if summary is turned off, what will be the solution?

Akhtar.shahbaz · June 2022

Hi @Saisri8568

you can use QUARTERVALUE function

Quater AVerage.png

Saisri8568 · June 2022

But, If we turnoff summary for above line item, that is not possible right?

whitby · June 2022

The recommended ways of doing it would be to use the summation or have an intermediate year only item.

If you're really short of space you can use TIMESUM(a, <FY-Q1>, <FY-Q4>) / 4 where Q1 & Q4 are retreived dynamically from your time system module - just a word of caution here that this isn't considered best practice as it is an inefficient way of doing the calculation.