Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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