Starting Q1 on November

wholelottared — Mon, 20 Dec 2021 21:08:46 GMT

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

];

Re: Starting Q1 on November

IamAlbinAntony — Wed, 06 May 2020 17:19:49 GMT

Use this,

'Q' & ceil(month(AddMonths(Date(COB_Date2),-8))/3)

Re: Starting Q1 on November

wholelottared — Wed, 06 May 2020 17:47:23 GMT

Excellent. This helped out so much. Thank you!!

topic Starting Q1 on November in App Development

Starting Q1 on November

Re: Starting Q1 on November

Re: Starting Q1 on November