Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There is straight table (detail report) and it has few derived columns through expression. Sometimes the expression output is NULL (expected).
We don't want those rows to be displayed in the report. How to suppress the NULL values in the report.
Hi,
you may need to change the expressions to only show values greater than 0
something like
IF(Sum(Sales) > 0,0,Sum(Sales))
In that case it shows 0 or the sum.
Hi,
You can try checking "Suppress When Value is Null" on the Dimension Tab.
Suppress When Value Is NULL
If this check box is enabled, the selected dimension in the Used Dimensions above will not be displayed in the chart if its value is NULL.
Bill
Sorry, you are correct
Sum(Sales) > 0