[]
        
(Showing Draft Content)

C1.Win.FlexGrid.AggregateEnum

AggregateEnum Enum

Specifies the type of aggregate function to calculate with the Aggregate(AggregateEnum, CellRange, AggregateFlags) and C1.Win.FlexGrid.C1FlexGridBase.Subtotal(C1.Win.FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.FlexGrid.AggregateFlags,C1.Win.FlexGrid.RowColFlags) methods.

Namespace: C1.Win.FlexGrid
Assembly: C1.Win.FlexGrid.8.dll
Syntax
public enum AggregateEnum

Fields

Name Description
Average

Returns the average value of the non-empty cells in a range.

Clear

Clear existing aggregates. This setting is used with the C1.Win.FlexGrid.C1FlexGridBase.Subtotal(C1.Win.FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.FlexGrid.AggregateFlags,C1.Win.FlexGrid.RowColFlags) 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 C1.Win.FlexGrid.C1FlexGridBase.Subtotal(C1.Win.FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.FlexGrid.AggregateFlags,C1.Win.FlexGrid.RowColFlags) method to create an outline tree without any numerical aggregates.

Percent

Percent of grand total. This setting is used with the C1.Win.FlexGrid.C1FlexGridBase.Subtotal(C1.Win.FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.FlexGrid.AggregateFlags,C1.Win.FlexGrid.RowColFlags) method to calculate the percentage of the grand total represented by each sub group. (This setting can't be used with the Aggregate(AggregateEnum, CellRange, AggregateFlags) 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).