Functions Reference

Chapter 11
|
Summary functions 153
Chapter 11
Summary functions
Summary functions produce a summary of all records in the found set, or subsummary
values for records in different groups. Formulas can contain more than one summary
function. Summary functions calculate more slowly than other functions because they
generate values for a range of records.
An alternate way to generate similar calculated results is to use Aggregate functions to
summarize data in related records (whether or not they appear in a portal). See Aggregate
functions, page 9 and information about summarizing data in portals.
Click the function name for details.
GetSummary
Format
GetSummary(summaryField;breakField)
Parameters
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.
The GetSummary function must be set up in the same table as the break field.
Data type returned
number, date, time, timestamp
This function Returns
GetSummary, page
153
The value of the summary field for the current range of records when the databas
e
file is sorted by the break field.