Aggregate Functions

You can specify advanced configuration for aggregate functions.

This table lists the aggregation functions of advanced configuration.

Function	Description	Syntax	Example
Count	Returns the total number of data items such as Invoice Lines and Invoice Distributions.	Count of <item type> {where <conditions...>}	Count of Invoice Distribution { where Exchange Rate > 75 AND Exchange Rate Type ="Fixed" } Greater Than 1000
Sum	Returns the total of all the values of the selected attribute.	Sum of All <rule attribute> {where <conditions...>}	Sum of all Invoice Line.Amount { where Match Type = "2-way Match" } Equals 1000 Sum of all Invoice Line.Amount { where Line Type = "Tax" } Between 1000 and 5000
Maximum	Returns the largest value in a set of values of the selected attribute.	Maximum of <rule attribute> {where <conditions...>}	Maximum of Invoice Distribution.Amount { where Distribution Match Type = "NOT MATCHED" } Equals 1000
Minimum	Returns the smallest number in a set of values of the selected attribute.	Minimum of <rule attribute> {where <conditions...>}	Minimum of Invoice Distribution.Amount { where Distribution Match Type = "NOT MATCHED" } Equals 1000
Average	Returns the average of all the values of the selected attribute.	Average of <rule attribute> {where <conditions...>}	Average of Invoice Line.Base Amount { where Expense Group = "Travel" } Less Than or Equal 1000