Alteryx Designer Desktop Discussions

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

Unexpected result from greater than or equal to operator

Electric
5 - Atom

I'm getting an unexpected result when using the >= operator in a formula. I've attached a simplified version of my workflow that shows the same behavior. The input column is a decimal value that comes in from a csv as V_String, and I use a Select tool to change the data type to double. Then I use a Formula tool to set a new column to a boolean value based on whether the input value is greater than or equal to a threshold. The formula works as expected when the input value is greater than the threshold or less than the threshold, but not when the value is equal to the threshold.

 

test_greater_than_or_equal_to_workflow.png

 

The attached example workflow uses a formula for >= 0.95, which returns the following results based on these input values:

0.94 false

0.95 false

0.96 true

 

test_greater_than_or_equal_to_result.png

 

Could someone help me figure out what I'm missing? I'm using Alteryx Designer v2021.2.1.35394, and I'm not able to upgrade at this time. Thanks!

2 REPLIES 2
binuacs
21 - Polaris

@Electric Your version of workflow also giving the correct result for me, I am using the latest version. Can you try the below option

image.png

Electric
5 - Atom

@binuacs thanks for verifying it works in your version! I tried your suggested fix and Alteryx still gives me the wrong answer.

 

As a workaround I will change it to greater than 0.949, which is close enough for my use case. I'll let my colleagues know about this issue.

 

We all hope to upgrade soon, but we still need to use some 32-bit database drivers. A colleague reported that this is cumbersome in newer versions of Alteryx and recommended the rest of us not upgrade yet.

Labels
Top Solution Authors