topic Re: Arcade Expression Calculations NaN values in ArcGIS Online Questions

Arcade Expression Calculations NaN values

JasonSimpson — Fri, 03 Apr 2020 17:42:13 GMT

I am in the process of creating a field calculation through expression for a popup and keep getting a return of NaN for records that have a zero dollar value in both fields. My expression is as followed.

Round(($feature["Field1"]/$feature["Field2"])*100,2) + "%"

Is it possible to create return text for all fields that have NaN as the value? I have created return values for fields with null values before, but I am uncertain if fields with NaN is possible. Thanks.

Re: Arcade Expression Calculations NaN values

KenBuja — Fri, 03 Apr 2020 18:01:45 GMT

You could wrap this in an iif to check if the value is zero.

IIf($feature["Field2"] === 0, "Zero", Round(($feature["Field1"]/$feature["Field2"])*100,2) + "%")‍

Re: Arcade Expression Calculations NaN values

JasonSimpson — Fri, 03 Apr 2020 18:24:20 GMT

Worked perfectly. Thanks for the speedy response.

Re: Arcade Expression Calculations NaN values

KenBuja — Fri, 03 Apr 2020 18:51:06 GMT

Glad to help! Don't forget to click the Mark Correct button

Re: Arcade Expression Calculations NaN values

XanderBakker — Fri, 03 Apr 2020 22:30:42 GMT

Hi Jason Simpson and Ken Buja ,

Question... does this work? I am getting this error message:

Parse Error:Syntax Error: Binary Operator not recognised ===

... when using 3 equal signs "===".

And do you have 0 values or is the field empty (null)? If so you may need to change the expression.

Re: Arcade Expression Calculations NaN values

KenBuja — Mon, 06 Apr 2020 12:38:33 GMT

You're correct, Xander Bakker that should just be

$feature["Field2"] == 0