I have 2 col current and last month in variance i am calculating current - last Please see value highlighted in yellow variance should be 0 but its giving some value and giving red popup Display value was rounded to 6 decimal places error
Any thought on it?
Solved! Go to Solution.
Hi @videet ,
in the formula tool to change the data types to Fixed Decimal. 19.6 is the default, which is 19 places to the left of the decimal point, 6 to the right. Set this accordingly, such as 19.2 to set it to two decimal places.
Hope this helps,
M.
Hi @videet
Alteryx support only max of 6 decimals. More than that would be rounded off.
https://help.alteryx.com/current/designer/data-types
Hope this helps 🙂