topic Re: thousands separators in Arcade in ArcGIS Dashboards Questions

thousands separators in Arcade

steffen4arcgis — Mon, 07 Jun 2021 15:41:57 GMT

Hi,

I'm looking for thousands separators in Arcade to use in ArcGIS Dashboard advanced formatting option. Which code should be used? Nothing found about.

Greats,

S.Peter

Re: thousands separators in Arcade

jcarlson — Mon, 07 Jun 2021 16:06:31 GMT

Try Text, maybe?

Text(123456, '###,###') -> 123,456

Re: thousands separators in Arcade

steffen4arcgis — Tue, 08 Jun 2021 07:25:35 GMT

It doesn't work. Does the number have to be formatted as text? I use the expression in ArcGIS Dashboard Indicator. --> middleText: ($datapoint.numbers, '###.###'),

numbers = integer

separator = "."

Re: thousands separators in Arcade

jcarlson — Tue, 08 Jun 2021 13:29:31 GMT

You'd need it to read

middleText: Text($datapoint.numbers, '###,###')

Personally, I prefer to do any manipulation of objects and variables outside of the return statement. That way if something's not working, you can try to debug it easier. I tested this in an indicator, and it does seem to be working. I'd double-check your expression.

var some_int = 123456; var mtext = Text(some_int, '###,###'); return { middleText: mtext }

Re: thousands separators in Arcade

Ade_Bruijn — Mon, 28 Mar 2022 14:55:15 GMT

For the users who prefer the .(period) as separator. Arcade needs , (comma) and (if I'm not mistaken) your organisation settings return a .(period)