Nulls in the expression

[#1]

hello friends...

how do I delete nulls in the expression?

I have date field, with null values (in expression).. Can I delete they??

[#2]

Hi Rodrigoreis:

In the properties of the chart on the tab dimensions, you have to check the option "Supress when value is null", i think this may work to you. Tell us if it was your answer.

Regards

Orlando

[#3]

I need delete nulls in the expression, in tab expression...

[prieper]

Typically you should not have a date as an expression - it would rather be a dimension (with the solution made by Orlando). In an expression you might wish to see results of an aggregation, like MAX(MyDate) - but this will ignore NULLs.

HTH
Peter

[#5]

If you want to do it from expression you can do it with a conditional:

If (FIELD <> NULL)

Your expresion.

Or

If you are going to do a SUM in your expression:

SUM ( {1 - $< FIELD = {NULL}>} FIELD)

Maybe if you explain us a little more about your question we can help you more.

Regards

Orlando