nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Field Calculating: need to display two decimal places

DaveMartin1

I'm attempting to calculate a field to show acres, displayed to 2 decimal places.

I've got field A representing area in sq. ft.. I've created a new field B to represent area in acres (to 2 decimal places).

When I created field B (for acres) I specified precision of 2. I've attempted both short and long integers for field type. In Field Calculator (for field I enter the phrase "A/43560' It calculates the field alright. Problem is, it's returning the answer, but it's rounding to the nearest whole number. (any acreage below 0.5 is displaying as 0)

How do I make it display Acres to two decimal places?

Thanks much in advance,

Dave

Find more posts tagged with

Accepted answers

XanderBakker

When creating the field the field scale sets the number of decimal places stored in a field. This parameter is only used in Float and Double data field types.

... but: If the input table is a personal or file geodatabase the field scale value will be ignored.

You can change the display properties of a field. In the attribute table, right click on the field header (the name) and select "properties". Next click on the button next to Numeric:

In the numeric format dialog, change the number of decimals:

All comments

Marco_AlejandroBonilla

If you need a 2 decimal visualization only, you can set that in the "Field Properties". There, inside the Numeric properties set the decimal places to 2. and you get the field. Also, if you need the value itself set to 2, you can use field calculator in your new field with this code Round("Field1",2).

Finally, remember that for decimal places you need a "Double" or "Float" data type. Not an "integer" type

XanderBakker

When creating the field the field scale sets the number of decimal places stored in a field. This parameter is only used in Float and Double data field types.

... but: If the input table is a personal or file geodatabase the field scale value will be ignored.

You can change the display properties of a field. In the attribute table, right click on the field header (the name) and select "properties". Next click on the button next to Numeric:

In the numeric format dialog, change the number of decimals:

DaveMartin1

Marco,

Thanks for your input. I typed the following

Round("Area_Acres",2)

in the Field Calculator, but I get error message

"Error running VBA code: Expected identifier"

DaveMartin1

That solves it Xander. Thanks for your help!

Dave

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

All Communities
Recent Posts
Followed Content
Community Help

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.