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.