topic Re: Display Numeric Value as Currency in ArcGIS Online Questions

Display Numeric Value as Currency

RachaelChasse — Thu, 16 Nov 2017 13:39:13 GMT

I am working with a feature service layer on ArcGIS online. I have data in an integer field that I would like to display as currency. I didn't see any options to configure the integer in currency format.

I tried to use the field calculator to convert the numeric data to text. In this field type I am able to add the $ in front of the number, but do not see how to insert the thousands separator on the data.

Is their a field calculation or expression that will do this in ArcGIS Online?

Thanks!

Re: Display Numeric Value as Currency

JakeSkinner — Thu, 16 Nov 2017 13:49:16 GMT

Hi Rachel,

An easier approach may be to create a custom pop-up. You can add a $ in front of your numeric field.

Re: Display Numeric Value as Currency

RachaelChasse — Thu, 16 Nov 2017 15:06:36 GMT

Hi Jake,

This was helpful--though it would be nice to have field formatting options similar to the desktop versions.

Thanks

Re: Display Numeric Value as Currency

JakeSkinner — Thu, 16 Nov 2017 15:23:47 GMT

One thing you can do is add the hosted service to ArcMap and create a local copy. You can perform your edit on the Text field, and then re-sync your edits back to the hosted service.

Re: Display Numeric Value as Currency

KellyGerrow — Tue, 22 Jun 2021 08:28:01 GMT

Hi Rachael Chasse‌,

Thanks for up-voting this idea, but I wanted to link it to this question so others can find it and upvote.

https://community.esri.com/ideas/5863‌

Re: Display Numeric Value as Currency

XanderBakker — Tue, 28 Nov 2017 00:59:55 GMT

As a side note, remember that you can also use a little bit of ArcGIS Arcade | ArcGIS for Developers to format the currency:

Resulting in examples like:

and

Re: Display Numeric Value as Currency

RachaelChasse — Wed, 29 Nov 2017 19:49:23 GMT

Thanks for this option as well! It does seem a bit clunky just to achieve a field format.

Re: Display Numeric Value as Currency

RachaelChasse — Wed, 29 Nov 2017 19:49:35 GMT

Thanks Kelly!

Re: Display Numeric Value as Currency

RachaelChasse — Wed, 29 Nov 2017 19:51:40 GMT

Hi Xander,

This is what I was hoping to find. I haven't used Arcade yet, but this seems like it would work well. I tried a few similar approaches but didn't have the syntax right. Thanks for the tip!

Re: Display Numeric Value as Currency

SarahRichardson — Mon, 08 Jan 2018 17:50:55 GMT

I added the expression below as suggested above by Xandar, it works in my web map, but not in the web app.

return Text($feature.TOTAL_ELIGIBLE_PROJECT_COST, '$ ###,###,###');

Re: Display Numeric Value as Currency

XanderBakker — Mon, 08 Jan 2018 17:53:36 GMT

What type of App are you using?

Re: Display Numeric Value as Currency

SarahRichardson — Mon, 08 Jan 2018 17:55:44 GMT

Hey Zander,

ArcGIS Online Web App that was created from a Web Map.

Thank you,

Sarah Richardson

Re: Display Numeric Value as Currency

XanderBakker — Mon, 08 Jan 2018 17:59:45 GMT

I can run some tests, but I would need the exact template name that you are using. Can you also include a screen capture of what is shown in the Web Map and in the Web App?

Re: Display Numeric Value as Currency

SarahRichardson — Mon, 08 Jan 2018 18:07:44 GMT

You just made me think it might have to do with the custom config our developer did to the web app template for our organization. Before asking you anything further I am going to investigate that angle. Thank you so much!

Re: Display Numeric Value as Currency

RobertAnderson3 — Tue, 27 Feb 2024 15:10:01 GMT

I know this post is rather old, but it's exactly what I wanted, but I also have another step, default formatting for French language currency is supposed to be like "150 000 $" with a space instead of a comma, however in the formatting it just breaks it and if I use "### ### $" it gives me "150000 ### $" instead. Is there a simple way to do this?