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
Solved! Go to Solution.
You could round the value maybe?
Round([Field1], .000001)=0
Cheers,
Mark
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
I need negative and positive values in the column. I want to eliminate all possible zero values from my column
Than just remove the ABS from the formula and add an >= 0.
[Column] < 0.0001 AND [Column] >= 0