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!

 

[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.

[TBWI]

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

[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]

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

[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?

[JeffreyThompson2]

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.

[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. 

[JeffreyThompson2]

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]

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.