Display Numeric Value as Currency

8738
14
Jump to solution
11-16-2017 05:39 AM
RachaelChasse
Occasional Contributor

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!

Tags (3)
14 Replies
SarahRichardson
New Contributor III

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, '$ ###,###,###');

0 Kudos
XanderBakker
Esri Esteemed Contributor

What type of App are you using?

0 Kudos
SarahRichardson
New Contributor III

Hey Zander,

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

Thank you,

Sarah Richardson

0 Kudos
XanderBakker
Esri Esteemed Contributor

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?

0 Kudos
SarahRichardson
New Contributor III

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!