thousands separators in Arcade

[steffen4arcgis]

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

[jcarlson]

Try Text, maybe?

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

[steffen4arcgis]

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 = "."

[jcarlson · Accepted solution]

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
  }

[Ade_Bruijn]

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