Hello GeoNet community,

I have a question regarding precision and scale of a new field. I am working on making a new field where I need total of 18 digits including 8 digits after decimal. For example the math is

900000000 + 1111*10000 + 1111*1 + 11111111/100000000

I need the result is 911111111.11111111

But, it shows 911111111.11111116

FYI, I have used Double and changed the precision and scale when I add the field. I will be appreciated if anyone has some ideas to explore.

Thanks

Reja

In attribute table

right click on the top of the field that you want to set specific precision . and click on properties

Inside Field Properties window. click on dots icon (

...) it is beside Numeric.choose from The left Numeric, then choose number of decimal places . and set it to be 8 as you want.