Summary functions available for chart data fields

Office Web Components

Summary functions available for chart data fields

The following table lists the summary functions provided by the AutoCalc Button image command used to summarize data fields.

Function Description
Sum Calculates the sum of the values.
Count Tallies the number of values. Empty values, such as zero-length strings (strings that contain no characters), are included in the count, but null values (values that indicate missing or unknown data) are not included.
Min Returns the smallest value in the field being summarized.
Max Returns the largest value in the field being summarized.
Average Returns the average of the values in the field being summarized.
Standard Deviation Returns the standard deviation of the values in the field being summarized, assuming the values are a sample of a larger population.
Standard Deviation Population Returns the standard deviation of the values in the field being summarized, assuming the values are the entire population.
Variance Returns the variance of the values in the field being summarized, assuming the values are a sample of a larger population.
Variance Population Returns the variance of the values in the field being summarized, assuming the values are the entire population.

Note  The summary functions available for a field depend on the type of data in the field. For example, if a field contains text, you can use only the Count function for that field.