Hiding zero figures in expression

[#1]

I want to hide all 0.00 in my table . Not suppress, I need the dimension to stay as its but hide the 0.00 in the expression @ Data

[swuehl]

Try a text color attribute expression (open the attributes by clicking on the small plus next to the expressions on expression tab):

=If( fabs( Sum(Value) )<=1E-12,White() )

replace sum(Value) with your expression

[#3]

is there another way? the white isn't really solving the problem

[swuehl · Accepted solution]

You can also use a condition in your expression, like

=If( fabs( Sum(Value) )> 1E-10, Sum(Value), '')

Again, replace Sum(Value) with your expression.

This should return an empty string instead of zero.

If this is not solving your problem, please describe in more detail what your problem is.