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; } } }

dynamic text currency format

MartieClemons

I created a map series in ArcGIS Pro and have dynamic text for cost values coming from a field which is double but no values have decimals. I would like the numbers to have commas every three numbers, e.g. for the value 1234567 I would like the dynamic text to show 1,234,567. Is this possible and if so, what is the code I need to use?

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

TomBole

Martie,

I don't know of any reasons why a dynamic text would ignore number formatting. In my quick test everything looked fine. Could be something specific with your data/layer/map/layout.

You might try using the Value dynamic text element found under Table Attribute and see if that works.

If you can't get this to work I would treat this issue as a bug and take it to technical support. They can be contacted at https://support.esri.com/en/contact-tech-support.

Tom

MartieClemons

Thanks (embarrassed). I keep forgetting that I need to save because I never started editing (ArcMap habits)! Anyway, the values look great in the table but when I reference the field in a dynamic text item in my map series, the formatting gets lost. Here's my dynamic text: $ <dyn type="page" property="attribute" field="MockupTablev3_TOTAL_COST"/>

MartieClemons

Tom, I applied the formatting of 0 decimals and checked the thousands separators box for the field but nothing happens in the attribute table.

TomBole

Yes, Dynamic Text will also honor the number formatting for the field.

MartieClemons

Thanks, Tom. This makes the table view show the correct format but will it transfer to the dynamic text in my map series? My work-around was to create a new text field, calc the numbers into it and then calc:

"{:,}".format('CostInteger')

Then I changed my dynamic text to point to this new text field. But if there's a way to use HTML in the dynamic text to format the numeric field as currency, then obviously that would be the best.

TomBole

Hi Martie,

You can set the comma separator by formatting the number for your field in the Fields View for the layer/table. See An overview of fields—Geodatabases | ArcGIS Desktop. The Table Frame will respect any number formatting you set. In the example below I've formatted the field "POP1990" to show the separators.

1. In the Contents pane right-click the layer or table you want to change

2. From the context hover over "Design" and click "Fields" from the pull-right menu to pen the Fields View

As you can see the Table Frame display the commas. I've also set the values in the table to be right-aligned.

1. In the Contents pane expand the Table Frame item

2. Right-click the field you want to change and click Properties to open the Format Table Frame Fields pane

3. In the Format Table Frame Fields pane click "Text Symbol"

4. Expand "Position" and click third Horizontal alignment option from the left

Hope this helps,

Tom

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Anmelden
Registrieren

Schnellzugriffe

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