How to remove or hide 0% values from an expression in straight table

[rsdhavle]

HI,

In my straight table chart i am getting 0% values in a chart i need to avoid those. I am not able to to that by checking property suppress zero value in presentation tab. What is the way to avoid those?

[its_anandrjs]

use suppress when value zero otherwsie in expression change like

Ex:-

=If(  Sum(Yourexpression) >0, Sum(Yourexpression))

This will avoid the 0% from the expression

[MK_QSL]

It may be possible that the actual value are 0.0024% or something like this.

If it is exactly 0%, suppress zero values should remove them.

Check by going to number tab and Fixed to 3 or 4 decimals..