topic Re: Experience Builder Expressions in ArcGIS Experience Builder Questions

Experience Builder Expressions

TBWI — Tue, 13 May 2025 14:32:34 GMT

I could use help with an Experience Builder expression. I would like to create a sum of multiple attribute fields. When I create a sum of each field individually, it works fine. When I try to summarize multiple fields, I don't get an error, but it will not show the total, just the expression name. Any help is greatly appreciated!

Re: Experience Builder Expressions

Sknittel_Geauga — Tue, 13 May 2025 14:57:17 GMT

My suggestion is to double check that each field's data source is correct, I often get that sort of response when I thought I had all set to "default" views but one was accidentally set to "selected features" and since I didn't have anything selected it didn't process.

Re: Experience Builder Expressions

TBWI — Tue, 13 May 2025 14:58:51 GMT

Thank you! I made sure that it is not on selected features, but I still have the same issue.

Re: Experience Builder Expressions

TBWI — Tue, 13 May 2025 15:03:48 GMT

As a follow-up, I was able to get a number when using the "List" widget, but it only summarizes data from features that are visible. How can I make it summarize all existing data in the table?

Re: Experience Builder Expressions

TimWestern — Wed, 14 May 2025 20:55:19 GMT

If the fields are a numeric type, and not a string, make sure none of the rows have a value of Null or NULL. I have seen some calculations fail because of a single 'null field' value.

Re: Experience Builder Expressions

JeffreyThompson2 — Thu, 15 May 2025 12:32:13 GMT

How many items are in your dataset? How big do you expect your final total to be? I am wondering if you are running into a limitation on how many calculations it can perform.

Re: Experience Builder Expressions

TBWI — Mon, 19 May 2025 14:15:45 GMT

I'm attempting to sum four columns (years) with about 30 features. We will add one column onto this calculation with each year of data collection.

Re: Experience Builder Expressions

JeffreyThompson2 — Mon, 19 May 2025 14:24:03 GMT

That sounds like a manageable number of calculations, but how big is your expected total. Could you be crossing the data size limit?

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/arcgis-field-data-types.htm

Re: Experience Builder Expressions

TBWI — Mon, 19 May 2025 15:11:38 GMT

The total right now for the four columns is about 260,000. What does integer vs big integer go up to? I see a caution using the big integer Field Types in ArcGIS Online, Best Practices and Compatibility.

I am currently using the "Integer" field type.

Re: Experience Builder Expressions

JeffreyThompson2 — Mon, 19 May 2025 15:22:02 GMT

You are exceeding the limit for a Short Integer. I don't know if this matters at all, especially since you are well within the size limit for a JavaScript Number.

Re: Experience Builder Expressions

TBWI — Wed, 04 Jun 2025 12:19:28 GMT

Thanks! However, we don't have any null values.