4 Quarter Average for a year

Options
Saisri8568
Saisri8568 Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Contributor
in Planning & Modeling

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

 

Saisri8568_1-1656334297007.png

 

Thanks.

 

Tagged:

Comments

  • Saisri8568
    Saisri8568 Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Contributor

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

     

  • Akhtar.shahbaz
    Akhtar.shahbaz Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Community Boss

    Hi @Saisri8568 

    you can use QUARTERVALUE function 

    Quater AVerage.png

     

  • Saisri8568
    Saisri8568 Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Contributor

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

     

  • whitby
    whitby Member, ALL USERS, GroupMember, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    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.

  • Akhtar.shahbaz
    Akhtar.shahbaz Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Community Boss

    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 shownQty 2.png

    QTY 3.png

  • whitby
    whitby Member, ALL USERS, GroupMember, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

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

Categories