Represents the aggregate type.
Members
| Member | Description |
|---|
| average | Calculates the average of the specified numeric values. |
| count | Calculates the number of data that contain numbers. |
| counta | Calculates the number of data that contain non-null values. |
| max | Calculates the maximum value, the greatest value, of all the values. |
| min | Calculates the minimum value, the least value, of all the values. |
| product | Multiplies all the arguments and returns the product. |
| stdev | Calculates the standard deviation based on a sample. |
| stdevp | Calculates the standard deviation of a population based on the entire population using the numbers in a column of a list or database that match the specified conditions. |
| sum | Calculates the sum of the specified numeric values. |
| varp | Calculates the variance based on a sample of a population, which includes numeric, logical, or text values. |
| vars | Calculates the variance based on a sample of a population, which uses only numeric values. |
Inheritance Hierarchy
Object
GC.Spread.Slicers.SlicerAggregateType
See Also