8. Working with RBF Report Specifications : Layout and Create Operations—Create New Report Components : Aggregates
 
Share this page                  
Aggregates
You use an aggregate function, such as sum or count, to calculate the value of a specified column up to the occurrence of a break. In RBF, an aggregate must appear in a footer for a report, page, or break. RBF calculates the aggregate value each time a break occurs in the specified footer.
The cut‑off point for data to be included in the calculation of an aggregate depends on whether the aggregate is simple or cumulative. For more information, see Simple and Cumulative Aggregates (see page Simple and Cumulative Aggregates).
The following table lists all of the available aggregate functions:
Aggregate Function:
Returns:
Any
1 if any data exists, 0 if none exists
Average
Mean average of all values in the column
Count
Count of all the values in the column
Minimum
Smallest value in the column
Maximum
Largest value in the column
Sum
Arithmetic sum of all the values in the column
Note these restrictions:
If the aggregate column is numeric, all of these functions are available.
If the aggregate column is a character or date data type, the any, count, minimum, and maximum aggregate functions are available. Additionally, you can take a sum of a date data type column, but only if date intervals (such as 1 day, 2 hours) are stored in the column. Taking a sum on absolute dates (such as December 13, 1988) results in an error.