Aggregate Functions (Report Builder 1.0)
Aggregate functions are used to perform calculations on a single value or a set of values to return a single value for a formula. For example, suppose you want to know the number of customers that purchase specific products from you. The SUM aggregate function can add the number of customers for each product together to return a single value for each product. Instead of the number of customers per product, suppose you want to know how many customers you actually have—that is, the number of unique instances of each customer. Using the COUNTDISTINCT aggregate function, you can determine how many unique customers you really have.
Aggregate functions can use the following data types: DateTime, Integer, Decimal, Float, EntityKey, String, or Numeric.
In This Section
Topic |
Description |
|---|---|
Returns the average (arithmetic mean) of all non-null values within a set. |
|
Returns the number of non-null items within a set. |
|
Returns the number of non-null distinct instances of an item within a set. |
|
Returns the maximum value in a set. |
|
Returns the minimum value in a set. |
|
Returns the standard deviation of non-null values in a set. |
|
Returns the population standard deviation of non-null values in a set. |
|
Returns the sum of all the values within in a set. |
|
Returns the variance of non-null values in a set. |
|
Returns the population variance of non-null values in a set. |