Filter Error on Doubles

squigley17

I have a value in a field designated a double and its value is 500. Filters are not properly applying on this field and I cannot figure out why. I have tested multiplying by 100 to see if there are any trailing values and if I change to a float, it works properly.. I have uploaded the field in a .yxdb for reference.

Test.yxdb

NickSm

@squigley17 

Took a look at your sample input, and found the same issue so investigated a little further. Turns out that if you allow your input enough decimal places, it is being rounded and is actually 499.999xxxx, which is why it's not passing your filter.  This may or may not be your desired result, but can always round to a certain number of decimals as needed.