Include Zero values is replacing the 0 with Null Value?

[dewan_abdullah]

After unchecking the "Include Zero Values" in the data handling section the zero is replaced with a null?!. The row with '0' or  ' - ' in the Totals Column should disappear.

I tried replacing the null with 0 functions but there is no use.

Please suggest a solution to this thanks.

[jonathandienst]

Suppressing zeros only applies if all the values are either null or zero. So the rows display because there are non zero values in the details.

[dewan_abdullah]

Actually i had some rows that had both 0 as well as Null value and it appeared as 0 in the totals and it wasn't included when i checked the button.

Thanks