topic Re: Sum() returning Nan Value in ArcGIS Pro Questions

Sum() returning Nan Value

godofsix — Wed, 20 Apr 2022 17:15:00 GMT

I'm trying to compute the percentage of a field using the sum of all the fields:

$feature.FullVaccin / Sum($feature.FullVaccin)

But every time I test, I get 1.... What am I doing wrong?

Re: Sum() returning Nan Value

KimberlyGarbade — Wed, 20 Apr 2022 17:45:19 GMT

Try something like this... I'm running this in field calculator and filtering on an ID, but edit at will.

var myid = $feature.COJ_FacilityID var mysum = 0 var myfs = filter(featuresetbyname($datastore,"BogusPumps",['Integer1'],false),"COJ_FacilityID = @myid") if(!IsEmpty(myfs)){ var mysum = ($feature.Integer1/Sum(myfs,'Integer1')) } return mysum

I ran this on the field "Float1" against this data:

Re: Sum() returning Nan Value

godofsix — Wed, 20 Apr 2022 17:54:58 GMT

Thanks so much. I tried it and I still get the same 1 as the output result

Re: Sum() returning Nan Value

KimberlyGarbade — Wed, 20 Apr 2022 18:03:46 GMT

Hmmm... what data type is FullVaccin? Also, are you using Field Calculator? If so, what is the data type of the field you are calculating?

Re: Sum() returning Nan Value

godofsix — Wed, 20 Apr 2022 18:04:53 GMT

Long

Re: Sum() returning Nan Value

KimberlyGarbade — Wed, 20 Apr 2022 18:18:12 GMT

If you are calc'ing into a Long also, it might not like getting numbers to the right of a decimal. Try calc'ing into Float or a Double.

Since percentage is going to be a decimal number by definition it only show 0 or 1 when you calc into an integer type.

if you multiple by 100 it will show an int.

Re: Sum() returning Nan Value

godofsix — Wed, 20 Apr 2022 18:13:20 GMT

Did and still got 1

Though, my ultimate aim is to use it for custom label in a web map

Re: Sum() returning Nan Value

KimberlyGarbade — Wed, 20 Apr 2022 18:20:30 GMT

Still getting 1? That is odd... are their any nulls in your table that you have to account for or does every row contain a FulVaccin value?

Re: Sum() returning Nan Value

godofsix — Wed, 20 Apr 2022 18:21:57 GMT

There are no nulls

Here is the table:

Re: Sum() returning Nan Value

KimberlyGarbade — Wed, 20 Apr 2022 18:47:15 GMT

Is "FullVaccin" off the page to the left?

Is the table joined with another table?

If you run a calc on Percentage again, and this time just do something simple like

($feature.Calculation * 1000)/Join_Count

(just using data I see in your table); it will return a useless number, but does that result also show 1 every time?

Re: Sum() returning Nan Value

godofsix — Wed, 20 Apr 2022 18:54:57 GMT

Sorry for the confusion... The FullVaccin is the fieldname on AGOL while Join_Count is for the original table in ArcPro..... and the table has not be joined with another table.

($feature.Calculation * 1000)/Join_Count

This works but did not give the accurate percentage

Re: Sum() returning Nan Value

godofsix — Wed, 20 Apr 2022 19:04:05 GMT

Whenever I use the (Sum($feature.Join_Count)) It returns the exact value for each row

Re: Sum() returning Nan Value

KimberlyGarbade — Wed, 20 Apr 2022 20:06:16 GMT

Hmmm... odd. This code works in AGOL, and if I edit the Layer through a feature service in Pro (this is different test data, but the same code as I originally sent structure wise)

var myid = $feature.Work_Unit_No var mysum = 0 var myfs = filter(featuresetbyname($datastore,"TestPoints",['TestInt'],false),'Work_Unit_No = @myid') if(!IsEmpty(myfs)){ var mysum = Round(($feature.TestInt/Sum(myfs,'TestInt'))*100,2) } return mysum

The reason your original code returned 1 every time was because it divided any number it found by itself:

$feature.FullVaccin / Sum($feature.FullVaccin)

So a tweak to the original code would be to create a feature set (in my example below called myfs) and pass that into the Sum function. If I want the myfs feature set to return all the rows in the Layer's table I can just remove the filter from my original response.

var myid = $feature.COJ_FacilityID var mysum = 0 var myfs = featuresetbyname($datastore,"BogusPumps",['Integer1'],false) if(!IsEmpty(myfs)){ var mysum = ($feature.Integer1/Sum(myfs,'Integer1')) } return mysum

If this doesn't work, I'm afraid I'm missing something that is right in front of me, but I just can't put my finger on.

Re: Sum() returning Nan Value

godofsix — Wed, 20 Apr 2022 20:44:53 GMT

Thanks so much