FlexGrid for WinForms

AggregateEnum Enumeration

C1.Win.C1FlexGrid Namespace : 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

`'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

See Also