Expressions in Dynamic Text EB

Question

I am trying to use the Text widget to display totals for a field.  That works fine for all records in the field using SUM{NAME} but I'd like to separate the totals by records of another field.  An example would be a table with NAME and MONEY.

I want to display the total money each person in the NAME field has.  Like:

Bob $25

Jane $30

Pedro $40

Also, if there is a blank (no name) in that field, don't show a total.

ahargreaves_FW · Answer

Can you expand on what version of Experience Builder you're referring to above? v11.5 enterprise does NOT support arcade..

kxu · Answer

Hi @KelleyCochran,

ArcGIS Experience Builder now supports Arcade. You could use Arcade Dynamic content.

Ke

KelleyCochran · Answer

Is there a list of Functions that are available?  Seems like it should be easy if I had the correct syntax.