Labeling and an extra zero

JasonSimpson

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

 

 

jcarlson

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

1. Your Text function included the hyphen and percentage as part of the formatting string
2. 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.