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?

Accepted answers

ntobon

@AbhilashR

Blue tools convert everything to Double for processing. That's probably the issue. Check below KB:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Big-numbers-and-Alteryx/ta-p/105952

One solution is to handle the numbers like that Strings. Or if you want to use the Numbers you can use the Round function or the CompareEpsilon function. See attached workflow.

sample_new.yxmd

All comments

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.

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.

20200302-FloatingPoint.yxmd

ntobon

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

Alteryx Customer Support

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703