Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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