Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You can try below expression:
=If(Sum(Sales) = 0, '-',Sum(Sales))
Or may be this:
Sum(Sales) * (Avg(Sales)/Avg(Sales))