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

[David Gadd]

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.

[Steve Martino]

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.

[AHunter3]

Alternatively, Sum (UniversalSelfJoinRelationship::Total_Cost)

 

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

 

 

[Steve Martino]

Looks like he left us...

@AHunter3 You would go thru all of that instead of just a clear 1 button-button bar with a calculation just for display?