Summary calc's needed of all records when in found subset
I have a table of $ transactions. In one layout I display all records and the summaries that total on the amount field represent an ongoing balance, or total at the bottom.
If I have a found subset of the $ transactions, is there any way that I can get the ongoing balance for the whole set of records?
For example, the records represent charge and payments, with the summary field reflecting balance due. If I'm only showing the current month of charges/payments, can I still get at the ongoing balance since the start?
The calculation, GetSummary(SummaryField;breakField), will give you the grand summary if you enter the SummaryField in both parameters. So if you want the total of all Transactions: