Sum() returning Nan Value

godofsix

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?

KimberlyGarbade

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.