Remove NULLs from the report

[#1]

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.

[rustyfishbones]

Hi,

you may need to change the expressions to only show values greater than 0

something like

IF(Sum(Sales) > 0,0,Sum(Sales))

[#3]

In that case it shows 0 or the sum.

[Bill_Britt]

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

[rustyfishbones]

Sorry, you are correct

Sum(Sales) > 0