Issue while creating a calendar for the app

[#1]

Hi,

I  am using the following code for 'Q'&Ceil(Month(ReportedDate)/3) AS CalendarQuarter and i am getting (Q,Q1,Q2,Q3,Q4) as values. When i remove the 'Q' from the code am just getting the quarter numbers(1,2,3,4). Unable to trace out the issue.

Regards,

Srikar

[#2]

Dear,

Srikar.

try to apply where condition at the end.

like

Test:

Load

-----

---------

-----------

where exist(ReportedDate,ReportedDate);

i hope it will help you.

Thanks,

Mukram.

[whiteline]

It seems that ReportedDate sometimes is null.

Try Ceil(if(not isnull(Month(ReportedDate)), Month(ReportedDate), 'NULL')/3) AS CalendarQuarter