summaryField -
field of type
summary, or an
expression that returns a reference to one.
breakField - field, or an expression that returns a reference to one. To calculate a
grand summary value, use the same summary field for both the summary field and the
break field parameters.
GetSummary must be set up in the same table as the break field.
This function produces subsummary values. If the database file isn’t sorted by the break field, the result is blank.
Use GetSummary to capture summary values when you want to:
GetSummary(Total Sales;Country) returns a summary of all records pertaining to the value in the Country field.
GetSummary(Total Sales, if(Number of Countries > 1, Country, Sales Zone)) returns a summary of Total Sales by Country if Number of Countries is greater than 1. Otherwise, it returns a summary of Total Sales by Sales Zone.
GetSummary(Total Sales;Total Sales) produces a summary of all records (similar to using a summary field, which is a total of total sales).
If(ThisCharge > 3 * GetSummary(AvgCharge;Customer), “Verify this charge”, “ “) displays
Verify this charge if the current charge is greater than three times the average charge.