Calculation Types

The following calculations can be performed in an Active Report.

Calculation	Applies to	Description
Count	All data, including text	Counts the number of occurrences of a value.
Distinct	All data, including text	Counts the number of distinct values within a field.
Sum	Numeric data	Gives the sum of all the fields in one column.
Avg	Numeric data	Gives the average value of the fields in the column.
Min	Numeric data	Shows the smallest value in the column.
Max	Numeric data	Shows the largest value in the column.
% of Total	Numeric data	Adds the percentage of the field relative to the sum of the field.