How to Create Report Totals and Subtotals › Key terms

Key terms

Here are a few terms used to discuss report subtotals and totals:

Aggregate function

A function that performs a predefined operation on a group of report rows. You can apply aggregate functions to report groups. Examples of aggregate functions are: average, high value, low value, count, and total.

Built-in function

A function that performs a predefined string, arithmetic, date/time, or trigonometric calculation on your report rows. You can apply built-in functions to report groups by including them in a COMPUTE statement. Examples of built-in functions are: gregorian date, cosine, and square root.

COMPUTE statement

A CA OLQ syntax statement used to perform calculations in the menu facility. You can apply the COMPUTE statement to report groups. Any time you specify a built-in or aggregate function, CA OLQ creates a COMPUTE statement. You can also specify your own COMPUTE statements.

Group by all

A report total including all rows in your report. Group by all means the same thing as report total.

Group field

A report column whose value is used to divide your report rows into groups. For example, you could list all of the company's employees grouped according to which department they work in. In this case, DEPARTMENT-NAME is the group field.

Report group

A set of report rows where each row contains the same value of the group field. For example, the personnel department is a report group with DEPARTMENT NAME as the group field. Each row in this group contains PERSONNEL in the DEPARTMENT NAME field.

Report subtotal

A computation applied to a report group. For example, if you grouped your employees by department, you can create report subtotals that apply to that group, computing the average salary in each department.

Report total

A computation that includes all of the rows in your report. For example, you can compute the total sales revenue earned by all of your employees. Note that a report total does not have to be a sum. It can also be an average, a counter, a high value, or a low value.