topic Re: Decimals NOT being truncated/rounded in ArcGIS Pro Questions

Decimals NOT being truncated/rounded

deleted-user-LNABNwA5CZcD — Wed, 25 Oct 2017 18:51:49 GMT

For points, I added some geometry fields (POINT_X and POINT_Y as automatically generated), which were created as Double type.

I want them to display as my label (e.g., "35.596821, -81.235600"). I went to the numeric formatting and changed to 6 as that's the number of decimal places I want.

For some (not all; most are fine), there is infinite repeat (e.g., "-81.39291999999999"). Here is my label code: Round($feature.POINT_Y, 6) + ", " + Round($feature.POINT_X, 6)

I've played around with the field calculator, even trying to create new fields and convert to different types, but that's not working.

HELP!!!

Re: Decimals NOT being truncated/rounded

DanPatterson_Retired — Sat, 11 Dec 2021 09:58:51 GMT

If you just need the field for labelling (that is another issue that can probably be solved directly)

I take it that is Arcade?

In python you can use the formatting characteristics builtin to convert a numeric value to string with complete control over the justification and number of decimals.

"{:10.6f}".format(-81.39291999999999)
'-81.392920'‍‍

I am sure equivalent abilities exist in other labelling languages

Re: Decimals NOT being truncated/rounded

deleted-user-LNABNwA5CZcD — Wed, 25 Oct 2017 20:11:52 GMT

Tried this in Python for the label, and it didn't work. Not sure what I'm missing. Is that truly all (with POINT_X replacing 81.39291999999) that should be needed?

Re: Decimals NOT being truncated/rounded

DanPatterson_Retired — Wed, 25 Oct 2017 20:22:02 GMT

Add a text field, use that as the convertor . The format conversion will perform if point_x is indeed a number, it should fail with an error otherwise.

If you can replicate my example in your python IDE using python 3.5, then there is something wrong with the labelling

My example is Python... make sure that you specify python if there is any other options

Re: Decimals NOT being truncated/rounded

deleted-user-LNABNwA5CZcD — Wed, 25 Oct 2017 20:25:54 GMT

Ok, figured it out just now. It was kind of backwards. I was able to go off the original Double field (POINT_X). In Python, and the decimal places and preserved characters were in opposite positions from what I thought:
'{:6.10}'.format([POINT_X])

Still seems inefficient, and something is off with the Round() function I'd still be curious to figure out, but at least it works. Thank you!

Re: Decimals NOT being truncated/rounded

JayantaPoddar — Wed, 25 Oct 2017 20:32:48 GMT

Ensure you are working on a layer pointing to a Feature Class, not an Event Layer.

What happens if you write a similar expression for Labeling as follows (Python Parser):

round(float([POINT_X]), 6) + ", " + round(float([POINT_Y]), 6)

Re: Decimals NOT being truncated/rounded

StayMappy — Tue, 12 Jun 2018 15:48:29 GMT

I have this problem and none of these solutions are working. I need the calculated number to be rounded. When I have tried to use the above solutions I keep getting this. This is causing a problem because this is how is is being displayed as well.

#arcpro‌ #decimals‌

Re: Decimals NOT being truncated/rounded

DanPatterson_Retired — Tue, 12 Jun 2018 15:58:40 GMT

it you calculate the values into a text field, as in my suggestion above, then you can control the output format easily

Re: Decimals NOT being truncated/rounded

StayMappy — Tue, 12 Jun 2018 16:05:22 GMT

This is what happened when I tried your code

Re: Decimals NOT being truncated/rounded

DanPatterson_Retired — Sat, 11 Dec 2021 09:58:54 GMT

is that a text field?

python parser in the field calculator

I just tried it

a = 91.1234567890
"{:6.2f}".format(a)
' 91.12'‍‍‍

Re: Decimals NOT being truncated/rounded

StayMappy — Tue, 12 Jun 2018 16:16:45 GMT

These are floats.

Re: Decimals NOT being truncated/rounded

DanPatterson_Retired — Tue, 12 Jun 2018 16:22:21 GMT

if you want labels, then I always use a text field to ensure that I get what I want in terms of formatting.

The inputs can be numbers (float double etc) but python formatting handles the conversions clearly and concisely without messing around with the actual numbers.

In your case if floates are the inputs, the first number is the width of the resultant string and the second number is the number of required decimals

Re: Decimals NOT being truncated/rounded

StayMappy — Tue, 12 Jun 2018 16:25:29 GMT

So I will probably have to make a new field that converts the float to string and then format? I need it initially in float because that field has to be calculating the acres of a polygon.

Re: Decimals NOT being truncated/rounded

DanPatterson_Retired — Tue, 12 Jun 2018 16:31:18 GMT

"{:10.6f}".format(!YourNumberFieldNameHere!)  # python, parser, calculate into a text field‍

try it... add the text field, set the parser, vary the numbers to suit

Re: Decimals NOT being truncated/rounded

StayMappy — Tue, 12 Jun 2018 17:33:02 GMT

This works. Thanks for all the help!

Re: Decimals NOT being truncated/rounded

DanPatterson_Retired — Tue, 12 Jun 2018 23:43:29 GMT

glad it worked Jessica