Assign an Aggregate Function to a Column

Use the Select Columns pane in the Account Analysis or SQL Author window to assign an aggregate function to a column. When you run the query, the aggregated values appear in the column instead of the actual value. Non-aggregated columns create the groups represented by the aggregated data.

To assign an aggregate function to a column

1. Do one of the following:

• Create an Account Analysis Query or Modify an Account Analysis Query.

• Create a SQL Statement or Modify a SQL Statement.

2. In the Select Columns pane, click the column and then, in the toolbar, click the Aggregate icon.  

3. Click a function. The original column name appears with the aggregate function name appended. For example, if you selected the "average" function for the Current Balance column, the Current Balance column name changes to Average of Current Balance.

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

Related Topics

Aggregate Functions

Select Columns Pane

Account Analysis

SQL Author

Queries