Deriving the Quarters

[Anonymous]

Hi All,

I have a Calendar i.e July-June and i need to derive Quarters like this:

July-Sep = Q1

Oct-Dec= Q2

Jan-Mar=Q3

Apr-June=Q4

I Have a column for Month, by using this how to derive Quarters?

[Gysbert_Wassenaar · Accepted solution]

'Q' & ceil(match(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')/3)

[sujeetsingh]

If you have the Date field then just use month start() or just nested iff as

If(wildmatch('July','Aug','Sept',Month),'Q1'--

[sujeetsingh]

This can also work

'Q' & ceil(month/3)