Specifies the type of aggregate to calculate over a group of values.
Namespace:
C1.Silverlight.FlexGridAssembly: C1.Silverlight.FlexGrid.4 (in C1.Silverlight.FlexGrid.4.dll)
Syntax
| C# |
|---|
public enum Aggregate |
| Visual Basic |
|---|
Public Enumeration Aggregate |
Members
| Member name | Value | Description | |
|---|---|---|---|
| None | 0 | No aggregate. | |
| Sum | 1 | Returns the sum of all values in the group. | |
| Count | 2 | Returns the count of non-null values in the group. | |
| Average | 3 | Returns the average value of the non-null cells in the group. | |
| Maximum | 4 | Returns the maximum value in the group. | |
| Minimum | 5 | Returns the minimum value in the group. | |
| Range | 6 | Returns the difference between the maximum and minimum values in the group. | |
| Std | 7 | Returns the sample standard deviation of the values in the group (uses the formula based on n-1). | |
| Var | 8 | Returns the sample variance of the values in the group (uses the formula based on n-1). | |
| StdPop | 9 | Returns the population standard deviation of the values in the group (uses the formula based on n). | |
| VarPop | 10 | Returns the population variance of the values in the group (uses the formula based on n). | |
| Custom | 11 | Raise the CustomAggregate event to calculate custom aggregates. |
See Also
