Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum({$<Vendor={"*"}>} Values)
or
Sum({$<Vendor=P(Vendor) >} Values)
or
Sum({$<Vendor*={"*"}>} Values)
Sum({$<Vendor={"*"}>} Values)
or
Sum({$<Vendor=P(Vendor) >} Values)
or
Sum({$<Vendor*={"*"}>} Values)
Hi Kathryn,
Have you checked the Suppress When Value Is Null box in the Dimension tab of your chart?
Cheers
Andrew
try like this in the expression =if(Sales>0,Sales)