Last quarter of FY

Options
tampara.dora
tampara.dora Member, ALL USERS Posts: 5 New Contributor
in Planning & Modeling

Hi I'm trying to get the last quarter of the FY formula. 

 

I have Q1FY22, Q2FY22, Q3FY22, Q4FY22. I need a boolean which checks the last quarter of the FY ie., Q4FY22. Please help.

Tagged:

Comments

  • pyrypeura
    pyrypeura Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Another way would be by going by quarter count and checking where modulo 4 equals  zero. Please find the screenshots attached. 

    pyrypeura_0-1661407853299.pngpyrypeura_1-1661407882825.png

     

    Best regards,

    Pyry

     

  • tampara.dora
    tampara.dora Member, ALL USERS Posts: 5 New Contributor

    Thank You!! That helped. 

Categories