Is it possible to create quarter on Month object

[#1]

Hello Everyone,

Any body please tell me is it possible to create Quarter object based on the month, i do not have date object with me

Thanks in advance

[agomes1971]

if(month<=3,'Quarter1',if(month>3 and month<=6;'Quarter 2';if(month>6 and month<10;'Quarter 3','Quarter 4')))

something like this...

[#3]

You can hard code this by this

If(match(Month,'Jan','Feb','Mar'),'Q1',If(match(Month,'Apr','May','Jun'),'Q2',if(match(Month,'Jul','Aug','Sep'),'Q3','Q4')))

hope above code will help you

regards

bhawna

[DavidFoster1 · Accepted solution]

If you have the month number then a simple function will work nicely.

Months:

LOAD

  *,

  'Q' & CEIL(TESTMONTH/3) AS TESTQTR;

LOAD * INLINE [

TESTMONTH

1

2

3

4

5

6

7

8

9

10

11

12

];