Display value was rounded to 6 decimal places error

[videet]

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?

[mceleavey · Accepted 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.

[atcodedog05]

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 🙂