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?
Solved! Go to Solution.
@ntobon - sample workflow attached.
@AbhilashR I am able to reproduce it with your workflow and sample data. I will be conducting further research onto this issue and I will be updating you soon.
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.
@ntobon: Thank you for the detailed solution! Blue tools converting everything to Double is something new I learnt today. Details like these can easily confuse many new users.
Not sure how, but it might be beneficial to create some sort of central repository of such edge cases for users to readily understand the product behavior, and learn its workarounds.