topic Re: Labeling and an extra zero in ArcGIS Online Questions

Labeling and an extra zero

JasonSimpson — Mon, 03 Jan 2022 17:46:11 GMT

Good afternoon, I am running into an issue when labeling on the new map viewer. For some reason, my arcade script is adding zeros onto a currency field. Below is my script. Can anyone advise me on what I may be doing wrong. Thanks. Below is my scripts

if ($feature.Change > 0 ) {return Text($feature["Change"], '$##,###,###' + ' - '+ Round(($feature["F__Change"])*100,2)+ "%")}

This turns a value of $1,900 into $190,000

Re: Labeling and an extra zero

jcarlson — Mon, 03 Jan 2022 19:16:08 GMT

Does the expression evaluate properly in other contexts, like in Pro or a Dashboard? At a glance, it looks like you're missing a closing parenthesis after your text formatting string.

return Text($feature["Change"], '$##,###,###' +...

I'm only working with hard-coded variables, since I don't have a layer handy to test this on, but I can't replicate the issue:

What you might try, though, is to establish variables and use template literals for your string, and see if that behaves any differently. At the very least, it's a nicer way of writing strings with multiple parts.

var c = $feature["Change"]; var f = $feature["F__Change"]; if (c > 0 ) { return `${Text(c, '$##,###,###')} - ${Round(f * 100, 2)}%` }

Re: Labeling and an extra zero

jcarlson — Mon, 03 Jan 2022 21:27:07 GMT

Just to follow up, it was a combination of issues.

Your Text function included the hyphen and percentage as part of the formatting string
Your formatting string included a "%" as a result of #1

It's lower down in the Function Reference page, but you can see that when "%" appears in the formatting string, it will multiply by 100 and format as a percentage.

By moving the parenthesis, the "%" is no longer in the formatting string, and the function won't trigger the multiplying by 100.