5 Quarters?

[pgalvezt]

Hi everyone,

I have a query where I call some date and I' ve created the normal calendar, but when I put 'Q' & Ceil(Month(Date_S)/3) AS Quarter.

The result is:

I don´t know why appear the Q in the dashboard. it would be Q1 to Q4 right?

Thanks.

[swuehl]

I would assume, that ceil(month(Date_S)/3) returns no result (NULL) for some record. Are you sure you have data for all records? If you are not sure, you might want to check the record with isnull before building your Quarter string.

edited:

like

if(isnull(Date_S)=0, YOUREXPRESSION ) as Quarter,

edited by swuehl

[SunilChauhan]

if(Ceil(Month(Date_S)/3)<>'Q',Ceil(Month(Date_S)/3))

[pgalvezt]

Gave me the same result. But I eliminated the 'Q' and my final table was 1,2,3,4.

Thanks Guys.