Forum Discussion
Unable to filter by decimal number!
Hi everyone, I was working on a table which has a variance which is a 1 decimal % column Now, when I try to filter the records from the filter pane setting show me the data greater than ...
grow up the decimal houses in variance, i think this number isn't 0, its like 0,00000001%
Thank your for your reply. The more I increase the 0s after the decimal, the number becomes bigger automatically. For example, if I set 0.01, it becomes 1.0%, if 0.001 then 10.0% automatically.
grow up in your variance field, your print show 0,0%, but i think its 0,0001% or any thing like this, for this dont be filtered.
try use ROUND in this filed to test.