topic Re: Arcgis Coding Issue in ArcGIS Online Questions

Arcgis Coding Issue

SpencerThompson — Mon, 09 Dec 2024 22:18:50 GMT

Hello, I'm very rusty with my Arcade abilities. Crash course: I have a table with 3 columns, I want my expression to take the values on 2 of them, divide them, and then put the result in a 3rd column.

The images attached are my attempt at this basic expression, and the error message that is thrown every time I try to run it. When I do the test one's, it says no errors and I'm stumped now. Any help is greatly appreciated!

Re: Arcgis Coding Issue

MErikReedAugusta — Mon, 09 Dec 2024 22:38:43 GMT

First thought: Does your dataset contain any null values in either the first or second column? Does it contain any zeroes in the second column?

Try this modification to see if it works:

var numerator = $feature.B01003_001E; var denominator = $feature.ALAND_SQKM; if (IsEmpty(denominator) || denominator == 0) { if (IsEmpty(numerator) || numerator == 0) return 0 else return null } return numerator / denominator

Re: Arcgis Coding Issue

AustinAverill — Tue, 10 Dec 2024 14:54:14 GMT

This for sure - Usually if I have something like this in a pop up, I will output all results as text and create exception messages for those div/0 and NaN errors.

Re: Arcgis Coding Issue

KenBuja — Tue, 10 Dec 2024 14:55:13 GMT

What kind of table are you using this in? Is this in a Data Expression for a Dashboard?

Re: Arcgis Coding Issue

SpencerThompson — Tue, 10 Dec 2024 17:18:28 GMT

Nope, same error message.

Re: Arcgis Coding Issue

SpencerThompson — Tue, 10 Dec 2024 17:21:59 GMT

This table is a hosted feature layer view. I have the population and the land area from 2017 and I'm trying to update the population value to 2022 in the pop density column. Then this data will be used in a dashboard once everything is set up.

Re: Arcgis Coding Issue

AustinAverill — Tue, 10 Dec 2024 17:22:49 GMT

Where are you attempting to implement this? What App?

Re: Arcgis Coding Issue

SpencerThompson — Tue, 10 Dec 2024 17:27:26 GMT

Solution: Double Check your data types before posting for help. I was trying to divide a Double by a String. Thanks for the help all!