Quarters missing dates

[Lisa2]

Hello, I have a created, in my Load script,

'Q' & CEIL(NUM(MONTH([My End Date]))/3) AS QTR,

but when I make a list box to list the quarters, I get a lonely "Q" because some items don't have an end date.  How do I get rid of this "Q"?  Do I put something in the expression like a where clause, like where date is Null?  If anyone could point me in the right direction. Thanks!

[yassinemhadhbi · Accepted solution]

Hello,

you can try this

if(isnull([My End Date])=false(),'Q' & CEIL(NUM(MONTH([My End Date]))/3)) AS QTR

This Expression will make the script only calculates The quarter when there's an end date, and data with a null end date will still be loaded