How to calculate the average from 1st quarter

Question

I need to create the Average of first Quarter (no matter if I'm in Jan/March or Dec) in the table like here:
Q1 YTD Average *12

How to achieve this?
#ApptioforAll

Accepted Answer

I resolved it:

1. Check in which Quarter I am now (based on the calendar) (Quarter Column):
=If(Mod(CurrentDate("M"),3)=1,Round(CurrentDate("M")/3,0)+1,Round(CurrentDate("M")/3,0))
2. Defined the formula to always turn proper Quarter values (Q1 YTD):
=if({Quarter Column}=1,Quarter(TCO Unit),if({Quarter Column}=2,Quarter(TCO Unit,-1),if({Quarter Column}=3,Quarter(TCO Unit,-2),if({Quarter Column}=4,Quarter(TCO Unit,-3),0))))
3. Then based on the Quarter YTD created average and multiplied by 12:
=12*({Q1 YTD}/3)

Seems to work! :)

#ApptioforAll

Apptio for All