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
Comments

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, <FYQ1>, <FYQ4>) / 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/37394929ea624e559655b8c8c2732679MOVINGSUM
Rob
0