Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Summary (total) of number field for all records (not just found records)?


David Gadd
 Share

Recommended Posts

This should be very easy, but Ii can't find how to make a field that shows the TOTAL $ for a number (currency) field for all records (not just for a found set). A SUMMARY field only produces results for a found set, so I assume I need a CALCULATION field, but which calculation?

Thanks for any help.

Link to comment
Share on other sites

Try

ExecuteSQL("SELECT sum(\"Total_Cost\")  FROM invoices " ; " " ; " " )

Change yours to match-red is the field name, green is the table name.  Escape either if you get the "?"

This will give you a total sum for the whole table.

Link to comment
Share on other sites

Alternatively, Sum (UniversalSelfJoinRelationship::Total_Cost)

 

using something akin to a field named One defined as 1 to anchor a selfjoin relationship of One=One

 

 

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use