Examples of Aggregates
Here are some examples of aggregates:
min(salary)
Specified in footer for dept, this element gives the minimum value of salary for all data rows in a dept.
average(age)
Specified in the footer for class, this element gives the average age for all data rows in a class.
count(name,200)
Specified in the footer for the report, this element gives the count of the number of data rows in the report + 200.
sum(transact,oldbal)
Specified in the footer for acct, this element gives the sum of transact, initialized by the value of oldbal at the start of each acct.
cumulative avg(height)
Specified in the detail text, this element gives the cumulative average of height since the start of the report.
cum(acctnum) sum(amt,balance)
Specified in the detail text, this element gives the cumulative sum of amt since the last change in acctnum and initialized by the value of balance at the last change of value in acctnum.