Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
'Q' & ceil(match(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')/3)
'Q' & ceil(match(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')/3)
If you have the Date field then just use month start() or just nested iff as
If(wildmatch('July','Aug','Sept',Month),'Q1'--
This can also work
'Q' & ceil(month/3)