Filter higher than 0 not working on summed rounded numbers ≤ 0.1

Ask the Community Get Answers
1

I ran into a problem with filters on a table where I wanted to show only the records with numbers greater than zero. It would show records with numbers greater than 0.1, but not 0.1 or less. I was able to recreate it in a test app ( Knack ). The field that I want to filter is a summary field that is rounded up. It works when the rounding is set to default, but not when it is set to round up or round down.

Has anyone else run into this problem?

2

It’s only on the pages side. I was able to create a work-around with a conditional yes/no field, with the condition of >0 = “yes”, and then filtering based on the yes/no.