I am trying to increase precision on some calculations. I'm looking to get as precise as possible. The problem is as I increase from 19.6 to 50.48, I am getting all null values. What is the workaround for this issue?
How are you trying to increase the precision? I did a work around using a "Select" tool --> Type "FixedDecimal" --> Size 50.48 for a test data. I see no issues.
I don't think that will work - the precision needs to be part of the calculation in the formula tool. Changing precision in a select tool will only have the effect of adding zeroes on to the end, which is not what I need.
@pkasik the issue in screengrab two is that your have more than 2 values in your integer column (ie a two digit number and a decimal). You need to make sure your fixed decimal lengths accommodate your values. I believe if you dig into the error/warning messages in your workflow you should see a message saying that the value didn't fit into your fixed decimal. This is not a standard truncating warning - it's telling you the value will be dropped resulting in the null.
I would caution that some of Alteryx's core math functions operate at a lower level of sensitivity than this and may truncate values. My hypothesis is that this is either behavior of the underlying C function - or it is how Alteryx is porting the data to the C function. I broke down and started using Python (where I bring numbers in as strings - and then have them leave as strings) to handle this level of sensitivity.
Alteryx isn't alone here - I see this kind of thing in other platforms as well (try select 1/14 as truncated; in snowflake and see the result).
