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