...
- To use a field or column in a function, on a joined table in the Report Designer panel, click and then click Aggregate.
- The type of aggregation possible depends on the data type of the field. In the Aggregate Functions pane, click the down arrow on Report Designer panel, click to the right of the field name and select one of the following:
- Avg: The average of all non-null values in the column
- Count: The count of all non-null values in the column
- Max: The maximum of all non-null values in the column
- Min: The minimum of all non-null values in the column
- Sum: The sum of all values in the column