Aggregate functions calculate values based on two factors: The input cell, which is usually, but not always a data field, and the report section that the function is located, relative to the input. The location of the function determines which, and how many cell values will be sent to the input. For example, an AggCount function in a Group Footer will count the values in the group, but that same function in a Report Footer will count the values for the entire report.
Note - Aggregate functions cannot be used in conditional formulas or ExpressView formula columns.
Click on a function name to continue:
AggAvg
Description | Returns the average of the values in a group. |
Remark | Accepts data fields or cell references. |
Example | Ex. aggAvg({OrderDetail.Quantity}) - returns the average quantity of sales orders. |
AggCount
Description | Returns the number of unique entities in a Data Category. |
Remark | The aggCount function uses the Data Category, not the Data Field. For example, the function “aggCount( {Officer.Salary} )” counts the number of Officers. You could replace “Officer.Salary” with any other field in the Officer Data Category and the function would still count the number of officers. |
Example | Ex. aggCount({Orders.ProductPrice}) - returns the number of sales orders. |
AggDistinctCount
Description | Returns the number of unique values in a group. |
Remark | Accepts data fields or cell references. |
Example | Ex. aggDistinctCount({OrderDetail.Quantity}) - returns the number distinct quantities in an order. |
AggMax
Description | Returns the maximum value in a group. |
Remark | Accepts data fields or cell references. |
Example | Ex. aggMax({OrderDetail.Discount}) - returns the largest discount. |
AggMin
Description | Returns the minimum value in a group. |
Remark | Accepts data fields or cell references. |
Example | Ex. aggMin({OrderDetail.Discount}) - returns the smallest discount. |
AggSum
Description | Returns the sum of the values in a group. |
Remark | Accepts data fields or cell references. |
Example | Ex. aggSum({OrderDetail.Quantity}) - returns the total quantity of units ordered. |
RunningSum
Description | Returns a running total of the input cell. |
Remark | Takes one, two, or three input: 1. The cell you want to sum. 2. OPTIONAL: A Data Field or Category. The running sum will reset to 0 whenever there is a new value for this Data Field or Category. NOTE. RunningSum should not be used with the AutoSum feature. |
Example | Ex. 1. RunningSum({Employees.Salary}) – returns running total of all the employee’s salary. 2. RunningSum({Employees.Salary}, {Employees.Region}) – returns a running total of employee’s salary for each region. 3. RunningSum({Employees.Salary}, {Company}) – returns a running total of employee’s salary for each Company. |
Next Article: Report Functions - Operators