odd True/False result

[LEXQ2005]

I want to filter out records that a/b < 0.4. Why the formula returns "True" for a record that is = 0.4? How can I fix it?

[Qiu · Accepted solution]

@LEXQ2005 
Maybe it involves some floating error?

This should fix.

[atcodedog05 · Accepted solution]

Hi @LEXQ2005 

Well I be dammed. Even I tried your workflow your logic should work but dont know why its not.

A change like this got it working. Its the logic with x100 both sides.

Hope this helps 🙂

You should drop a mail to support@alteryx.com to get more clarity.

[atcodedog05]

Yes i am guessing the same as @Qiu said. But the issue is not clearly visible.