topic Re: No continuity among number formats in ArcGIS Pro Questions

No continuity among number formats

DanielMatranga — Wed, 13 Feb 2019 20:07:34 GMT

I've already pointed this problem out in a previous post, but thought I'd share another case with some details.

I start by wanting to make a map that has percentages labeled on polygons.

Added a feature class to my map, which has data like this:

Name	Percentage
John Doe	0.12
Jane Doe	0.25

In ArcGIS Pro, I go to Data tab > Fields

and format the Percentage column to be Percentage with no decimals:

What I expect to see in the table is this:

Name	Percentage
John Doe	12%
Jane Doe	25%

Instead, however, I see this:

Question: why does Pro round percentages when I specify no decimal places?

To resolve the issue, I try setting it to 2 decimal places, which yields this:

This is incorrect, because the values are actual 0.54, 0.64, etc. and I expect them to translate to 54%, 64%, etc.

Next, I set out to just find an Arcade expression so that I can display percentages on the polygons and not worry about the number formatting. So I find an expression like this:

Text($feature.PERCENTAGE, '#%')‍‍

So that's cool, now I end up with labels like this:

So I try to actually make a map for a slide with a legend (something the software is supposed to be able to do well, right?). I go to my Layout view, Insert > Legend and get this:

Yikes, what a mess. So now am I supposed to manually make a legend? I don't see another way to handle this.

Re: No continuity among number formats

TedKowal — Thu, 14 Feb 2019 15:35:50 GMT

I am not an ArcPro User (due to its inability to access ms access personal geodatabases) however, Percentages is either a format or a calculated value based upon the number stored in databases. There is no field type of Percentage. So the number is stored as a plain numeric or decimal value. You would have to choose either:

1. Number represents a fraction. Adjust it to show as a percentage -- (Format)

2. Or apply a calculated value ([Percentage (your field name)]*100

Hope this helps....

Re: No continuity among number formats

MattWilkie3 — Wed, 22 May 2019 22:03:55 GMT

The inconsistency extends to ArcGIS Online also. Here's some ideas to vote up so we don’t have to contend with this forever, maybe:

It would be really, really good to have and use the same technique across all areas, from Desktop to Online, instead of creating a distinct attribute column for each scenario.

Re: No continuity among number formats

XanderBakker — Wed, 22 May 2019 22:36:37 GMT

I assume you have tried this option...

Re: No continuity among number formats

Anonymous User — Thu, 23 May 2019 13:09:22 GMT

Your data is in decimal form (0.12, 0.25, etc.), also considered fractional format. Select the second option, "Number represents a fraction. Adjust it to show as a percentage". This will convert decimals to whole number (12, 25, etc.)

If your data were already whole numbers (12, 25, 63.24, etc.) then you would go with option one, "Number already represents a percentage".