Solved! Go to Solution.
Hi @klonergan
I can confirm this happens on my machine as well. My assumption is it may be due to how the information is stored behind the scenes. Nonetheless I'll look to raise it internally for a fix in future releases.
ROOT CAUSE:
That happens to numbers that are too big to fit in a double datatype. Numbers get treated as double on the backend and those numbers are too large to fit into a double data type, so they can't be searched very well. If you search by a single digit they should come up.
Large Numbers are not handled correctly due to the limitations of the FixedDecimal type and it should be documented. I have submitted this feedback to the Alteryx Technical Writing Team.
WORKAROUND:
It's better practice to handle a big number like that as a String. Search works fine if the fields are converted to string.