topic Re: Can't Sum Integer Field (but can sum small integer) in ArcGIS Experience Builder Questions

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

ZachBodenner — Fri, 26 Dec 2025 18:06:46 GMT

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:

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: {} };

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: {} };

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

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

DanPatterson — Fri, 26 Dec 2025 22:10:42 GMT

why are lines 8 in both images the same? (eg smallIntegerField)

did you forget to change line 8 to integerField in line 8 in the second image?

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

ZachBodenner — Fri, 26 Dec 2025 22:15:13 GMT

Heh yes I did forget to change that but the error message is coincidentally the same which is probably why I missed it. I've continued testing too and it does seem like other math functions like min(), max() and mean() all work on the long integers, it's just sum() that is causing the error. I've tested with multiple long integer fields in multiple datasets at this point.

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

DanPatterson — Sat, 27 Dec 2025 00:13:54 GMT

The only thing that remains is the possible sum. Would the sum exceed the possible range of values permissable for long integers? Other math functions wouldn't be affected

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

ShengdiZhang — Mon, 29 Dec 2025 03:25:19 GMT

Hi @ZachBodenner ,

I tried to reproduce the issue with my own data, and both integer and big integer worked fine for me. So it doesn’t seem like a value range problem. Do you have a sample dataset I could use to try and trigger the bug on my side?

Thanks,

Shengdi

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

ZachBodenner — Mon, 29 Dec 2025 14:02:22 GMT

I wouldn't think so because I had previously done this exact function on the same dataset, but hosted rather than referenced. So in theory it wouldn't exceed the value unless there's something different about that particular data type across different types of web services.

Edit: interestingly, the sum does in fact exceed the long integer storage value. The value is 10.8 billion, while the long integer (correct me if I'm wrong) is 2.1 something billion. Thing about hosted vs. referenced still stands, but there ya go.

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

ZachBodenner — Mon, 29 Dec 2025 13:56:41 GMT

Yes, though it's almost certainly too big to upload here. Can you let me know how best to deliver it to you?

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

ShengdiZhang — Tue, 30 Dec 2025 02:33:56 GMT

Hi, could you share the URL of the hosted service? You can DM it to me.