Handling Null Values in Expression (Sum)

[rishimessi19]

Hi

I have a data set (Below Picture) with Dim and Sales as two attributes. I want to show sum in a straight table. I see that '0' is being displayed when we sum two null values. How can we display '-' when we have missing values in a sum expression?

[swuehl]

Have a look at

Re: Nulls and Zeros in SUM function

and the other referenced thread therein also.

[trdandamudi]

You can try below expression:

=If(Sum(Sales) = 0, '-',Sum(Sales))

[sunny_talwar]

Or may be this:

Sum(Sales) * (Avg(Sales)/Avg(Sales))