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!
