AggregateEnum Enumeration

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

Member	Description
Average	Returns the average value of the non-empty cells in a range.
Clear	Clear existing aggregates. This setting is used with the C1FlexGridBase.Subtotal method to clear any existing subtotals, usually before calculating new subtotals.
Count	Returns the count of non-empty cells in a range.
CountDistinct	Returns the count of unique non-empty cells in a range.
Max	Returns the maximum value in a range.
Min	Returns the minimum value in a range.
None	No aggregate. This setting is used with the C1FlexGridBase.Subtotal method to create an outline tree without any numerical aggregates.
Percent	Percent 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).
Std	Returns the sample standard deviation of the values in a range (uses the formula based on n-1).
StdPop	Returns the population standard deviation of the values in a range (uses the formula based on n).
Sum	Returns the sum of all values in the range.
Var	Returns the sample variance of the values in a range (uses the formula based on n-1).
VarPop	Returns 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.C1FlexGrid.AggregateEnum