Unexpected result from greater than or equal to operator
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
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
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!
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Electric Your version of workflow also giving the correct result for me, I am using the latest version. Can you try the below option
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
