Quarter Start

[kevbrown]

I have the following dimension in a line garph - Ceil(Month(ukmpsmr_risk.INCEPTION_DATE)/3) - my problem is for some of my customers they're year starts in March so i need the quarters to start from March, the current expression will always start at January, any ideas?

Kev

[sivarajs]

Add 3 months to the date using addmonths will help

Ceil(Month(Addmonths(ukmpsmr_risk.INCEPTION_DATE,3))/3)

[kevbrown]

If i then select April it still says quarter 2, April should be part of quarter 1

[Anonymous]

Then try with

Ceil(Month(Addmonths(ukmpsmr_risk.INCEPTION_DATE,-3))/3)

April, May and June will appear in Quarter 1

July, August and September will appear in Quarter 2,

and so on..

Take into account last quarter will appear now in Quarter 1.  I am not sure hat is what you need...

Marc.

[kevbrown]

Tried that, the quarters work for the labels but the sum expression doesn't.  If i just select March, April and May the total is correct, if I select April to September Quarter 1 is inflated

[aveeeeeee7en · Accepted solution]

Use this:

Ceil(Num(Month(Addmonths(ukmpsmr_risk.INCEPTION_DATE,-2)))/3)   // It will start your month from March

You can also create Quarters in the Script:

'Q'&um(Month(Addmonths(ukmpsmr_risk.INCEPTION_DATE,-2)))/3)   // It will start your month from March

Regards

Av7eN

[kevbrown]

worked a treat, thanks