AggregateFunction Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the aggregate function to be used by reporting tools to summarize column values.
public enum AggregateFunctiontype AggregateFunction = Public Enum AggregateFunction- Inheritance
-
AggregateFunction
Fields
| Name | Value | Description |
|---|---|---|
| Default | 1 | The default aggregation is Sum for numeric columns. Otherwise the default is None. |
| None | 2 | Leaves the aggregate function unspecified. |
| Sum | 3 | Calculates the sum of values contained in the column. This is the default aggregation function. |
| Min | 4 | Returns the lowest value for all child members. |
| Max | 5 | Returns the highest value for all child members. |
| Count | 6 | Returns the rows count in the table. |
| Average | 7 | Calculates the average of values for all non-empty child members. |
| DistinctCount | 8 | Returns the count of all unique child members. |