Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Filter Doesn't Seem to be Working Correctly

mccartycp
7 - Meteor

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

mccartycp_1-1583176796003.png

 

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

mccartycp_2-1583176828748.png

 

I have a custom filter setup:

mccartycp_3-1583176903138.png

And it is working - except for the -0.70:

mccartycp_4-1583176950791.png

And it sorts correctly: 

mccartycp_6-1583177066149.png

 

 

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

mccartycp_5-1583177003474.png

 

 

What the heck am I missing?

13 REPLIES 13
JamesRoundy
5 - Atom

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
7 - Meteor

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

JamesRoundy
5 - Atom

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
15 - Aurora
15 - Aurora

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

CharlieS
17 - Castor
17 - Castor

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
Alteryx
Alteryx

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

Alteryx Customer Support

 

ntobon
Alteryx
Alteryx

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
15 - Aurora
15 - Aurora

Version - 2018.4.4 in my case

ntobon
Alteryx
Alteryx

@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? 

Labels