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)
Thanks.
Best Answers
-
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
1 -
Of course - I'm forgetting your video 😅 https://youtu.be/PvimWuX5jVw
0
Answers
-
hi @Saisri8568 - try using YEARVALUE(a).
0 -
Thank you. But, if summary is turned off, what will be the solution?
0 -
0
-
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?
https://help.anaplan.com/37394929-ea62-4e55-9655-b8c8c2732679-MOVINGSUM
Rob
0
