script to Shows Quarter Numbers

[Dharanidharan_DD]

Hi,

Can u help me to create like this below,  Its a quarter Number till now for the repeated Q1 Q2 Q3 Q4

63
63
63
60
60
60
57
57
57
54
54
54
51
51
51
48
48
48
45
45
45
42
42
42
39
39
39
36
36
36
33
33
33
30
30
30
27
27
27
24
24
24
21
21
21
18
18
18
15
15
15
12
12
12
9
9
9
6
6
6
4
4
4

[Or]

Your table is just a bunch of numbers. What is your input data, and what is the expected output?

[Dharanidharan_DD]

Hi @Or ,

Thank You for the reply

I have quarter Field respect to the month, I need the Quarter Number Field, (Overall Quarter Num From starting)

Month   Quarter  Quarter Number

Jan         Q1                21

Feb         Q1               21

Mar         Q1               21

Apr         Q2               22 

May       Q2                22

Jun        Q2                22

[Or]

I'm not sure what the "starting point" is - it's not mentioned anywhere in either of your posts.

If we assume that Jan Q1 2020 is Quarter Number 21, and each following quarter increases that count by 1, something along the lines of:

 4*(Year(DateField) - 2020)+20  // Start with 21 in 2020 as 20 from year and 1 will be from month below

+

Ceil(Month(DateField)/3) // 1-3 will return 1, 4-6 will return 2, etc

If that's not quite what you meant, you should be able to adapt this based on the actual quarter numbering system you're using without too much trouble.

[Dharanidharan_DD]

hi @Or 

Need periodQtrNum..  like this table

[H_Julian]

I'd do two tables

SourceTable:

Load * ,

ceil( Periodnum/4, 1 ) as PeriodQtrNum //

From Source;

[Dharanidharan_DD]

Hi @H_Julian 

Thanks ... Refer the above pic

PeriodQtrNum Repeats for only 3 times. And main thing is its in the different sequence  3 3 3 6 6 6 9 9 9...

[Or]

If you already have this PeriodNum field, then getting the desired QuarterNum should be easy...

Floor(PeriodNum/3)*3

[Dharanidharan_DD]

Hi

PeriodQtrNum Field Displays the unique Period Numbers, (Period Num which is at the starting of each Qtr) for each Qtr.  Not the Qtr Num.

ref: above table