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

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.