<ST_DataConsolidateFunction> (Data Consolidation Functions)

Data consolidation functions specified by the user and used to consolidate ranges of data.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value

Description

<average> (Average)

The average of the values.

<count> (Count)

The number of data values. The Count consolidation function works the same as the COUNTA worksheet function.

<countNums> (CountNums)

The number of data values that are numbers. The Count Nums consolidation function works the same as the COUNT worksheet function.

<max> (Maximum)

The largest value.

<min> (Minimum)

The smallest value.

<product> (Product)

The product of the values.

<stdDev> (StdDev)

An estimate of the standard deviation of a population, where the sample is a subset of the entire population.

<stdDevp> (StdDevP)

The standard deviation of a population, where the population is all of the data to be summarized.

<sum> (Sum)

The sum of the values.

<var> (Variance)

An estimate of the variance of a population, where the sample is a subset of the entire population.

<varp> (VarP)

The variance of a population, where the population is all of the data to be summarized.

Referenced By

<dataConsolidate@function> (§3.3.1.27); <dataField@subtotal> (§3.10.1.22)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_DataConsolidateFunction">
	<restriction base="xsd:string">
	<enumeration value="average"/>
	<enumeration value="count"/>
	<enumeration value="countNums"/>
	<enumeration value="max"/>
	<enumeration value="min"/>
	<enumeration value="product"/>
	<enumeration value="stdDev"/>
	<enumeration value="stdDevp"/>
	<enumeration value="sum"/>
	<enumeration value="var"/>
	<enumeration value="varp"/>
	</restriction>
</simpleType>