Creating Quarters, why do i get a single Q?

[#1]

Hi,

I'm using next formula to compute quarters based on a dataset from an xls:

This way I end op with

Q1, Q2, ,Q3, Q4 and a Q in my selection boxes. How can i get rid of it?

Thanx!

[its_anandrjs · Accepted solution]

Hi,

It is due to the null values you just need to exclude null values try the below code

If(isnull(DateColumn) = 0, 'Q' & Ceil(Month(Date(DateColumn))/3)) as Quarter by this you exclude null values.

Regards,

Anand

[#3]

Thankx!