Aggregate functions perform a calculation on a set of values and return a single value. All aggregate
functions ignore null values. To include aggregated values in your report, use the Aggregates node in Edit Expression editor.
You can specify a scope to identify which set of data to use for the calculation by using data scope functions.
| Function |
Description |
Return Type |
Example |
| Avg(Expression) |
Returns the average of all non-null values from the specified expression. |
The return type is determined by the type of the evaluated result of expression. |
Avg(Fields.ListPrice * Fields.Quantity) |
| Count(Expression) |
Returns a count of the non-null values from the specified expression. |
Returns an Integer. |
Count(Fields.EmployeeID) |
| CountDistinct(Expression) |
Returns a count of the distinct values from the specified expression. |
Returns an Integer. |
CountDistinct(Fields.EmployeeID) |
| First(Expression) |
Returns the first value from the specified expression. |
Determined by the type of expression. |
First(Fields.Phone) |
| Last(Expression) |
Returns the last value from the specified expression. |
Determined by the type of expression. |
Last(Fields.CustomerID) |
| Max(Expression) |
Returns the maximum value from all non-null values
of the specified expression. |
Determined by the type of the expression. |
Max(Fields.ListPrice) |
| Min(Expression) |
Returns the minimum value from all non-null values
of the specified expression. |
Determined by the type of the expression. |
Min(Fields.Quantity) |
| Sum(Expression) |
Returns a sum of the values of the specified expression. |
Returns the summation of all expression values in the most precise expression data type. |
Sum(Fields.ListPrice * Fields.Quantity) |