This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am a bit confused myself to be honest. The reference states that it should allow a maximum precision of 50.
"The length (precision) of a fixed decimal is equal to the width of the integer (left side of decimal) plus the decimal point plus the width of the scale (right side of decimal). If a number is negative, the negative sign is also included in the length.
Alteryx defaults a Fixed Decimal to 19.6. The maximum precision is 50, inclusive of the decimal point and negative sign (if applicable)."
It sounds like a bug to me, but maybe someone else has an explanation for it.
I think i got the reason why 19.10 is giving Null results.
The number of characters in "" is 17 (including '-' and '.') and when you give the FD length 19.8 the total characters become 18 (as a '0' gets added at the end. Similarly when you give the FD length 19.9 the total characters become 19 (as two zeroes gets added at the end) which still satisfies the FD length condition.
But when you give 19.10 then it breaches the total length as the number of characters become 20. Hence it results in Null.