topic Arcade Expression is not working properly. Keeps showing estimated population as "N/A" in ArcGIS Arcade Questions

Arcade Expression is not working properly. Keeps showing estimated population as "N/A"

lisaswarnNJDOH — Wed, 20 Aug 2025 13:56:47 GMT

Hello,

I am in pop up configuration, and my expression was working properly but now, it is not, instead showing N/A

below is my code:

Re: Arcade Expression is not working properly. Keeps showing estimated population as "N/A"

DanielFox1 — Wed, 20 Aug 2025 14:21:13 GMT

Hi @lisaswarnNJDOH

If your layer has been republished or updated I would start by checking that all your fields are the same and match exactly.

Does your data contain null or empty values for the selected features? You could use the Arcade Debugger in the pop-up configuration to inspect $feature values directly, try printing raw values to confirm they are populated.

You can also add in a temporary line to the expression return $feature; to test if you can isolate the issue down further.

I hope this helps in some way.

Re: Arcade Expression is not working properly. Keeps showing estimated population as "N/A"

HaydenWelch — Wed, 20 Aug 2025 15:31:45 GMT

Since you're referencing the '_EstPop' fields dynamically, they might not being loaded. You can fix that by including an Expects() call:

Expects($feature, 'TEETHLOST_EstPop', 'ARTHRITIS_EstPop', 'CANCER_EstPop', 'COPD_EstPop', 'CHD_EstPop', 'CASTHMA_EstPop', 'DEPRESSION_EstPop', 'DIABETES_EstPop', 'BPHIGH_EstPop', 'HIGHCHOL_EstPop', 'OBESITY_EstPop', 'STROKE_EstPop' )

https://developers.arcgis.com/arcade/function-reference/feature_functions/#expects

Now that we know that, we can use it at the top of the script and make everything more dynamic:

Additional note on using Proper, since it's a builtin you get massive performance boosts for using it. If a string is encountered more than 5 or so times, the interpreter will actually cache the result and avoid re-calculating it. Which is great if you have a lot of similar strings that are being titlecased

Re: Arcade Expression is not working properly. Keeps showing estimated population as "N/A"

lisaswarnNJDOH — Wed, 20 Aug 2025 14:42:40 GMT

This is a layer I made, so no updates. The fields are correct because the rest of the code is working properly just not the estimated population. It was working perfectly yesterday and today I noticed it. There are null values for about 6 rows.

Re: Arcade Expression is not working properly. Keeps showing estimated population as "N/A"

RPGIS — Wed, 20 Aug 2025 16:44:23 GMT

There are also, in addition to what @HaydenWelch mentioned, there are a few ways in which your code can be rewritten to be simpler.

Utilize the When function when there are multiple if-if else statements. The when function behaves in a similar manner and ultimately returns the same thing. You can specify the default value as null to basically do nothing if none of the when conditions are met.
When there are multiple values being made but logically are the same then it is best to create a dictionary of those values rather than resulting to multiple statements.
You can also use the example below in conjunction with Expects.

Expects($feature) var Values = {} for( var i in $feature ){ Values[i] = $feature[i] } /* Another option Expects($feature) var Values = Dictionary($feature).attributes */

Just for fun I am trying to rewrite your code for suggestive purposes.

Re: Arcade Expression is not working properly. Keeps showing estimated population as "N/A"

HaydenWelch — Wed, 20 Aug 2025 16:26:43 GMT

I do like the When function in some cases, but I also feel like it can make your code harder to read later. I prefer to just have a bunch of if statements with no else/elifs after and let them fallthrough to a base return:

function f(a) { if (a > 10) { return 'A is Greater Than 10' } if (a == 9) { return 'A is 9' } if (a == 1) { return 'A is 1'} return 'A is an unknown value' } function g(a) { return When( (a > 10), 'A is Greater Than 10', (a == 9), 'A is 9', (a == 1), 'A is 1', 'A is an unknown value' ) }

Those are identical, but it's basically up to the programmer which they think is more readable lol

Re: Arcade Expression is not working properly. Keeps showing estimated population as "N/A"

RPGIS — Thu, 21 Aug 2025 17:55:57 GMT

Here is what I came up with but without having any sample data it is the best that I could do. This is just a suggestive means but feel free to modify and ask any further questions.

function RoundN(val){ iif( TypeOf(Number(val))=='Number', Round(Number(val)), 0 ) } function Risk(n){ iif( Number(n)>0, Round(n/10)*10, 0 ) } function ordinal(n) { var r = n % 10 var t = When( r==1, "st", r==2, "nd", r==3, "rd", "th" ) iif( !IsEmpty(n), Concatenate(n,t), null ) } // Set the default values var RootFieldNames = [ "TEETHLOST","ARTHRITIS","CANCER","COPD", "CHD","CASTHMA","DEPRESSION","DIABETES", "BPHIGH","HIGHCHOL","OBESITY","STROKE" ] // Set the coomon names for all fields var RootName = 'CDC_PLACES_2175' var percName = '_percentile' var popName = '_EstPop' // Creates a new line var nl = TextfFormatting.NewLine /* Get all attributes in the feature Loop through and populate the dictionary */ Expects($feature,'*') var Values = {} for( var i in $feature ){ Values[i] = $feature[i] } /* Another option Expects($feature) var Values = Dictionary($feature).attributes */ /* Create the dictionaries to be populated using the information gathered below */ var Convert = {} var PopVals = {} var PCTVals = {} for( var r in RootFieldNames ){ r = RootFieldNames[r] var pctname = RootName + '.' + r + PercFName var popname = r+PopFName //Get the field name and round if the field is in the if( HasKey(pctname,Values) ){ PCTVals[r] = RoundN(Values[pctname]) } else if( HasKey(popname,Values) ){ PopVals[r] = PCTVals[r] = Values[popname] } //Populate the conversion dictionary with the default values Convert[r] = When( r=="TEETHLOST","All teeth lost", r=="CANCER","Cancer (non-skin) or melanoma", r=="CHD","Coronary heart disease", r=="CASTHMA","Coronary heart disease", r=="CHD","Current asthma", Includes(["ARTHRITIS","DEPRESSION","DIABETES","OBESITY","STROKE"],r),Proper(r), r=="BPHIGH","High blood pressure", r=="HIGHCHOL","High cholesterol", r=="COPD", r, null ) } // Set the score and limit dictionary var Limits = { VeryHigh:[], High:[], Medium:[] } var PctScores = { VeryHigh:[], High:[], Medium:[] } // Loop through all keys in the conversion dictionary for( var i in Convert ){ var pop = PopVals[i] var pct = PCTVals[i] // Set value dictionary with the default value var Def = { label: Convert[i], score: pct, estPop: pop } // Get the rating of the measured risk percentage var R = When( Risk(pct)==90, 'VeryHigh', Risk(pct)==80, 'High', Risk(pct)==70, 'Medium', Null ) /* If the rating is a key value in the limit dictionary then populate both the limit dictionary with the default value and the percentage score array with the percentages */ if( HasKey(Limits,R) ){ Push( Limits[R], Def ) Push( PctScores[R], pct ) } } // Set the html array var HTMLText = [] // Loop through the limit dictionary for( var l in Limits ){ var vals = Limits[l] if( Count(vals) > 0 ){ // Get the score array and sort from highest to lowest of distinct values var valscores = Reverse( Sort( Distinct( PctScores[l] ) ) ) // Set the html text var html = ""+l+" (" + Count(vals) + "):"+nl /* Set the empty paragraph html array Loop through the array of score values and reassign the index as the value */ var pHTML = [] for( var i in valscores ){ i = valscores[i] // Loop through the array of score values and reassign the index as the value for( var v in vals ){ v = vals[v] /* If the score matches the value update the paragraph html array with the text erase the value from the array break the loop */ if( v.score == i ){ var Text = 'style="text-indent:15%">' + Proper(v.label) + " (" + ordinal(v.score) + " Percentile and Est Pop: " + v.estPop + ")" Push( pHTML, Text ) Erase(vals,v) break } } } /* If the count of the array below is greater than 0 then conatenate the list of values and insert a new line */ if( Count( pHTML ) > 0 ){ pHTML = Concatenate(pHTML,nl) Push(HTMLText, html+pHTML) } } else{ Console('There were no risks in this catergory') } } /* Return the concatenated html if the count of the html list is greater than 0, otherwise return the default text */ iif( Count(HTMLText) > 0, Concatenate(HTMLText,nl), "No conditions at Medium or above" )