AggregateEnum Enumeration

Specifies the type of aggregate function to calculate with the C1FlexGridBase.Aggregate and C1FlexGridBase.Subtotal methods.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Enum AggregateEnum 
   Inherits System.Enum

'Usage
 
Dim instance As AggregateEnum

public enum AggregateEnum : System.Enum

public enum class AggregateEnum : public 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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

C1.Win.C1FlexGrid Namespace