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

What is label expression for formatting a number to have thousands separator and decimals?

RickWarner

I can do this in the table, but would rather have ability in the labeling of the map.

Vind meer berichten getagd met

Accepted answers

AntGiles

RIck,

If you are after python specific code then you can use the str.format(), see examples here:

Python String Format Cookbook | mkaz.com

All comments

AntGiles

Rick,

Have a look at this article:

Make Numeric Labels More Readable

You could also use the FormatNumber function in vbscript:

http://www.esri.com/news/arcuser/1104/files/vbscript_label.pdf

Regards

Anthony

KevinBell

def makeMoney(n):

import locale

locale.setlocale(locale.LC_ALL, '')

S = locale.currency(float(n), grouping=True)

return S

AntGiles

RIck,

If you are after python specific code then you can use the str.format(), see examples here:

Python String Format Cookbook | mkaz.com

RickWarner

Thank you Kevin,

Is there a way to remove the decimals from the currency, but have the thousands separator. I’m dealing with Sales Price of real estate and there usually no decimal place, ie. 100,000 for a home.

Richard

image001.jpg

KevinBell

from the google:

http://stackoverflow.com/questions/23428660/python-locale-currency-to-0-decimals

Hopefully helpful?

Luke_Pinner

A one liner (modified from code on Stack Overflow😞

<SPAN class="str">"{:,}"</SPAN><SPAN class="pun">.</SPAN><SPAN class="pln">format</SPAN><SPAN class="pun">(int(</SPAN><SPAN class="pln">value</SPAN><SPAN class="pun">))</SPAN>

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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