Excluding Nulls from expression

[khaycock]

How can i go about excluding nulls from an expression? I don't want to see any data in my line graph for when there is no data in the vendor field.

I looked online and managed to find this expression:

Sum({$<Vendor-={$(vVendorNoNull)}>}Values)

Where vVendorNoNull = Concat( DISTINCT TOTAL If(IsNull(Vendor), Chr(39) & Vendor & Chr(39)), ', ')

Which i was expecting to work but resulted in my chart saying that the allocated memory was exceeded. Any other ideas?

Thanks

[Anonymous · Accepted solution]

Sum({$<Vendor={"*"}>} Values)

or

Sum({$<Vendor=P(Vendor) >} Values)

or

Sum({$<Vendor*={"*"}>} Values)

[effinty2112]

Hi Kathryn,

                         Have you checked the Suppress When Value Is Null box in the Dimension tab of your chart?

Cheers

Andrew

[tajmohamed30]

try like this in the expression =if(Sales>0,Sales)