Table scale and precision

3108
4
06-09-2015 02:09 AM
ayllaBAK
New Contributor II

Hi,

I have a problem. I need to not have decimal places after number (field type is  double). Whenever I work with data in  ArcGIS 10.1 and later load that same data in any other program I've got 11 decimal places after round number. That creates a problem in other programs. I tried to save my data by converting with Feature class to feature class and manually correct the scale and precision to 0 but  again when I upload data to old ArcView I have 11 decimal places. How can I restrict/limit my field data to 0 decimal places. I

Thank you for your help.

0 Kudos
4 Replies
JayantaPoddar
MVP Esteemed Contributor

Hi Aylla,

You can add a new  field (Datatype: LONG). Just write the fieldname in the Field Calculator within Int() function.

e.g. Field_Long = Int([Field_Double])



Think Location
NeilAyres
MVP Frequent Contributor

And, if you didn't want to simply truncate your double into an integer you could do this :

Field_Long = Int([Field_Double] + 0.5)

SepheFox
Frequent Contributor

It is not necessary to convert to integer when calculating the long type field equal to the double or float field. In fact, if you simply calculate it as Field_long = Field_double, the numbers will be rounded correctly..

NeilAyres
MVP Frequent Contributor

Sephe,

spot on!

FieldDoubleLong.jpg