Filter zero

[sandhyaharyani]

I have a formulae on column A (Type Double) to filter out zero values and the formulae is Column A = 0 but with this not all my 0 values are like getting captured. For example a value like -1.00133443203809E-13 which is zero in an excel is not getting captured by this filter. How can I filter in all values = zero

[MarqueeCrew · Accepted solution]

You could round the value maybe?

Round([Field1], .000001)=0

Cheers,

Mark 

[grossal]

I'd go with the usual coding workaround:

ABS([Column]) < 0.0001

The ABS wrapper makes sure that the value is positive and we don't get issues with negative values.

Best

Alex

[sandhyaharyani]

I need negative and positive values in the column. I want to eliminate all possible zero values from my column

[grossal]

Than just remove the ABS from the formula and add an >= 0.

[Column] < 0.0001 AND [Column] >= 0