Forum Discussion

k3rz0rg's avatar
k3rz0rg
Icon for Advocate III rankAdvocate III
2 years ago

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 ...
Need Help
LeandroDeodato's avatar
LeandroDeodato
Icon for Resolver II rankResolver II
2 years ago

grow up the decimal houses in variance, i think this number isn't 0, its like 0,00000001%

k3rz0rg's avatar
k3rz0rg
Icon for Advocate III rankAdvocate III
2 years ago

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. 

  • LeandroDeodato's avatar
    LeandroDeodato
    Icon for Resolver II rankResolver II
    2 years ago

    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.