Select to view content in your preferred language

Can't Sum Integer Field (but can sum small integer)

28
0
3 hours ago
Labels (1)
ZachBodenner
MVP Regular Contributor

Hello everyone,

I'm working with Arcade here in Experience Builder dev edition 1.19. I want to run a sum function on a filtered featureset, but I'm running into a strange issue where Small Integer fields (and doubles) can be summed, but Integer (long integer in my dataset) cannot. Here's the fields of the map service:

ZachBodenner_2-1766772344575.png

 

And here's trying to sum a small integer (note, not really a field I actually want to sum, just using it to illustrate the point)

var fs = getFilteredFeatureSet($dataSources["dataSource_12-18c82b170ef-layer-17"]);  // Assessed Value

//var integerField = sum(fs,"Assessed_Value")
var smallIntegerField = sum(fs,"Quintile_Year")


return {
  value: smallIntegerField,
  text: {}
};

ZachBodenner_0-1766772176413.png

 

But, when I attempt to sum a field that is simply an Integer...

var fs = getFilteredFeatureSet($dataSources["dataSource_12-18c82b170ef-layer-17"]);  // Assessed Value

var integerField = sum(fs,"Assessed_Value")
//var smallIntegerField = sum(fs,"Quintile_Year")


return {
  value: smallIntegerField,
  text: {}
};

ZachBodenner_1-1766772228669.png

This one has me stumped. Anyone run into this yet?

Happy mapping,
- Zach
0 Kudos
0 Replies