Expressions in Dynamic Text EB

[KelleyCochran]

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.  

[DanCopKac]

If you have access to the SQL table you could make a view then bring that view (virtual table) into Experience Builder:

Select NAME, Sum(MONEY) from TABLE group by NAME.

Incredibly easy in SQL. Looking for an answer in Experience Builder as well. 

[KelleyCochran]

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

[Ke_Xu]

Hi @KelleyCochran,

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

Ke

[ahargreaves_FW]

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