Feedback

  • Contents
 

Assign an Aggregate Function to a Query Column

Use the Select Columns pane in the Generate Report Record window to assign an aggregate function to a column. The export file includes the aggregated values instead of the actual value. Non-aggregated columns create the groups that the aggregated data represents. For more information about aggregate functions, see Aggregate Functions.

To assign an aggregate function to a query column

  1. In the Generate Report Record window, go to the Select Columns pane.

Select Columns pane

  1. Click the column and then, in the toolbar, click the arrow next to the Aggregate icon. A list of functions appears.

Aggregate functions list

  1. Click a function. The original column name appears with the aggregate function name appended. For example, if you selected the "average" function for the Linked Current Balance column, the Linked Current Balance column name changes to Average of Linked Current Balance. In the export file, the average account balance for all the linked accounts appears.

  2. To delete an aggregated function, click the column name and then click the Aggregate icon.

Related Topics

Query Columns

Queries