Need Help With Arcade Sum() Expression

[deleted-user-1_r2dgYuILKY]

I'm new to Arcade. I'm trying to summarize square footage for rooms of a certain classification (containing the prefix 'CR_') in a Map Series using dynamic text. The expression builder says my Arcade expression is valid, but nothing is being printed to the dynamic text box. 

[WendyHarrison]

Hi Levi,

you'll need to rework the return line.  The sum should be an element in the array, not the second parameter in concatenate.

Concatenate( [ "Total: ", Sum(sqft) ] )

or cast the sum to text

Concatenate( [ "Total: ", Text(Sum(sqft)) ] )

----------------

does your UsableArea field contain a list of values that you're summing?  or are you trying to do something else?

[deleted-user-1_r2dgYuILKY]

No, I'm trying to create a single sum for all features that contain the text prefix 'CR_'. I've been reading that Arcade can't be used on multiple records??? What is the point? I could accomplish this in seconds in Python, but I can only use Arcade expressions for Dynamic text in a Map Series. 

[WendyHarrison]

To do that you need access to FeatureSet to loop through features.  The dynamic text expressions are part of the Visualization profile and don't have access to this functionality.  There is another way to do what you're looking for through dynamic text.  I've spoken with a colleague and she'll be here shortly to take you through it.

thanks

Wendy

[deleted-user-1_r2dgYuILKY]

Cool, thanks!

[XanderBakker]

I think  would first you the Filter function to get the list of records that start with CR_ and then apply the sum to that list.

[AubriKinghorn]

Hi Levi,

To get the result you want, you want to use Table Statistic dynamic text instead of Table Attribute. This type of dynamic text allows you to pick a field within your data to calculate a statistic on. You can refine the calculation to use All Rows, Visible Rows, Map Series Rows, or a Custom SQL query. You can then add additional static text to your text element, instead of using Concatenate. 

This help topic Add dynamic text—Layouts | ArcGIS Desktop has some more information on Table Statistic and Table Attribute dynamic text types and when to use each.

Cheers,

Aubrianna

[deleted-user-1_r2dgYuILKY]

That was the first approach I tried, but I just figured out what the problem was. I needed a definition query on the layer itself that filters out rooms that don't meet the criteria. Then I can have table statistic dynamic text that sums just those values. 

[Anonymous User]

Is it possible to create a query that performs a calculation and then produces the sum of that calculation? In my map layout I would like to display the total length of roads driven for "Red Route" but in order to calculate the total length I first need to multiply the length field by the number of lanes that exist for each road (without storing this in the attribute table). Currently I have been able to display the total by number of lanes (dynamic text: table statistics):

Or the lane distance for each feature (dynamic text: table attribute):

but I can't seem to produce the grand total.