Applying a Summary Function

You can assign a summary function to columns that contain numeric values in your report. A summary function is a summarization technique that performs calculations on values in columns, groups, or in the entire report.

1.

Click the down arrow next to a report column that contains numeric values.

2.

Select Summary from the menu, then select your summary type.

Summary Types and Descriptions

Function Name	Description
None	No summary function assigned
Average	Calculates the average value in a given column
Count	Counts the items in a group or report Note:Count does not require a numeric value
Count Distinct	Counts the distinct occurrences of a certain value in a group or report Note:Count Distinct does not require a numeric value
Max	Identifies the highest or largest value in a column
Min	Identifies the lowest or smallest value in a column
Sum	Calculates a total sum of the group or report (group level, and running total in the report footer)

The numeric values in the column update.

3.

Save the report.

Open topic with navigation