nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Experience Builder Expressions

TBWI

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!

Find more posts tagged with

ArcGIS Online

Accepted answers

All comments

TBWI

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

TBWI

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.

Jeff.Thompson@arlingtontx.gov_arlingtontx

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

TBWI

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.

Jeff.Thompson@arlingtontx.gov_arlingtontx

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.

TimWestern

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.

TBWI

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?

TBWI

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

Sknittel_Geauga

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.