﻿ AggregateEnum Enumeration | FlexGrid for WinForms | ComponentOne
FlexGrid for WinForms | ComponentOne
C1.Win.FlexGrid Namespace / AggregateEnum Enumeration

In This Topic
AggregateEnum Enumeration
In This Topic
Specifies the type of aggregate function to calculate with the C1FlexGridBase.Aggregate and C1FlexGridBase.Subtotal methods.
Syntax
```'Declaration

Public Enum AggregateEnum
Inherits System.Enum```
`public enum AggregateEnum : System.Enum `
Members
MemberDescription
AverageReturns the average value of the non-empty cells in a range.
ClearClear existing aggregates. This setting is used with the C1FlexGridBase.Subtotal method to clear any existing subtotals, usually before calculating new subtotals.
CountReturns the count of non-empty cells in a range.
CountDistinctReturns the count of unique non-empty cells in a range.
MaxReturns the maximum value in a range.
MinReturns the minimum value in a range.
NoneNo aggregate. This setting is used with the C1FlexGridBase.Subtotal method to create an outline tree without any numerical aggregates.
PercentPercent of grand total. This setting is used with the C1FlexGridBase.Subtotal method to calculate the percentage of the grand total represented by each sub group. (This setting can't be used with the C1FlexGridBase.Aggregate method).
StdReturns the sample standard deviation of the values in a range (uses the formula based on n-1).
StdPopReturns the population standard deviation of the values in a range (uses the formula based on n).
SumReturns the sum of all values in the range.
VarReturns the sample variance of the values in a range (uses the formula based on n-1).
VarPopReturns the population variance of the values in a range (uses the formula based on n).
Inheritance Hierarchy

System.Object
System.ValueType
System.Enum
C1.Win.FlexGrid.AggregateEnum