4 Quarter Average for a year
How to get 4 quarter average of the same year for all quarters in a separate line item(Quarter formatted)
We can calculate in many ways but recommended & easy with the summary method
below is another way of doing but required some mapping as shown1
Of course - I'm forgetting your video 😅 https://youtu.be/PvimWuX5jVw0
hi @Saisri8568 - try using YEARVALUE(a).0
Thank you. But, if summary is turned off, what will be the solution?0
you can use QUARTERVALUE function0
But, If we turnoff summary for above line item, that is not possible right?0
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.1
Why not use MovingSum() with the average parameter?