Filter Doesn't Seem to be Working Correctly

[mccartycp]

I have a very odd situation that has never occurred before. I have a bonus factor that I've calculated:

The data is Fixed Decimal 19.2 in all tools, inputs and outputs:

I have a custom filter setup:

And it is working - except for the -0.70:

And it sorts correctly: 

I've verified that it's not hiding decimals through a temporary HTML output:

What the heck am I missing?

[JamesRoundy]

It is definitely a bug. Just tested it and even using > .69 AND < .71 it still won't find it. Only way I can filter is to convert to string.

[mccartycp]

I had to do that as well, thanks for looking at it.

[JamesRoundy]

I actually created a macro to test all numbers beween .01 and 10.00 and all of these are not able to be found: 

0.35
0.41
0.47
0.57
0.69
0.70
0.82
0.83
0.94
0.95
1.14
1.36
1.39
1.41
1.59
1.61
1.64
1.66
1.68
1.70
1.84
1.86
1.89
1.91
1.93
1.95
2.28
2.53
2.57
2.72
2.78
2.82
2.97
3.28
3.53
3.57
3.72
3.78
3.82
3.97
4.56
4.81
5.56
5.81
6.56
6.81
7.56
7.81

[AbhilashR]

I agree, definitely a bug. Interestingly, anytime the data has a 7 in it, it ignores it.

[CharlieS]

It seems like another case of floating point error. Continuous variable operations (numeric sort) should not be affected in a significant way, but I recommend converting to to an integer if you need to identify a particular value. The Multi-Field Formula tool is handy for this as it can apply the formula and change the field type at the same time.

[ntobon]

We are currently looking into it and we will be in touch as soon as possible.

Alteryx Customer Support

[ntobon]

I tested it in 2019.4.6 and I am not able to reproduce the issue. I got the expected results:

My Input (sorted descending):

Bonus Factor
1.00
-0.47
-0.52
-0.55
-0.55
-0.57
-0.57
-0.59
-0.61
-0.63
-0.69
-0.70
-0.70
-0.70
-0.70
-0.70
-0.70
-0.70
-0.71
-1.00
-1.00

1. FILTER: ([Bonus Factor]>-0.71 AND [Bonus Factor]<-0.69)

- True:
Bonus Factor
-0.70
-0.70
-0.70
-0.70
-0.70
-0.70
-0.70

- False:
Bonus Factor
-0.61
-0.59
-0.57
-0.63
-0.55
-0.55
-0.57
-0.47
-0.52
-1.00
1.00
-0.69
-0.71

2. Bonus Factor * 100

FILTER: [Bonus Factor]!=100 AND [Bonus Factor]!=-100 AND [Bonus Factor]!=-50 AND [Bonus Factor]!=-70

- True:
Bonus Factor
-61
-59
-57
-63
-55
-55
-57
-47
-52
-69
-71

- False:
Bonus Factor
-70
-70
-70
-70
-70
-70
-70
-100
100

What version do you have? 

[AbhilashR]

Version - 2018.4.4 in my case

[ntobon]

@AbhilashR  I tested it in Version - 2018.4.4 and got the same results above. It works as expected.

Could you please send me your workflow with input data so I can easily test on my end?