In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

odd True/False result

LEXQ2005
8 - Asteroid

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?

 

1.PNG

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@LEXQ2005 
Maybe it involves some floating error?

This should fix.

Capture1.PNG

atcodedog05
22 - Nova
22 - Nova

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.

atcodedog05_0-1611297650208.png

 

Hope this helps ðŸ™‚

 

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

atcodedog05
22 - Nova
22 - Nova

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

Labels
Top Solution Authors