Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I'm trying to start Quarter 1 on November via this formula
'Q'&If(Month(QuarterStart((COB_Date2)))='1',4,Div(Month(QuarterStart((COB_Date2))),3))
but it starts Q1 on May instead. How can I get Q1 to start on November while still retaining all Q1-Q4 for the year. I'm loading an inline table by the way. Thanks!
Full ex.
Table2:
LOAD *,
'Q'&If(Month(QuarterStart((COB_Date2)))='1',4,Div(Month(QuarterStart((COB_Date2))),3))
Inline [
COB_Date2, Sales
01/01/2018, 20
02/01/2018, 30
05/01/2018, 68
08/01/2018, 25
10/01/2018, 65
];
Use this,
'Q' & ceil(month(AddMonths(Date(COB_Date2),-8))/3)
Excellent. This helped out so much. Thank you!!