<ST_TotalsRowFunction> (Totals Row Function Types)

An enumeration that specifies what function is used to aggregate the data in a column before it is displayed in the totals row.

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)

Represents the arithmetic mean.

<count> (Non Empty Cell Count)

Represents a count of the number of non-empty cells.

<countNums> (Count Numbers)

Represents the number of cells that contain numbers.

<custom> (Custom Formula)

Represents the formula provided in totalsRowFormula.

<max> (Maximum)

Represents the largest value.

<min> (Minimum)

Represents the smallest value.

<none> (None)

No total row.

<stdDev> (StdDev)

Represents the estimated standard deviation.

<sum> (Sum)

Represents the arithmetic sum.

<var> (Var)

Represents the estimated variance.

Referenced By

<tableColumn@totalsRowFunction> (§3.5.1.3)

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

<simpleType name="ST_TotalsRowFunction">
	<restriction base="xsd:string">
	<enumeration value="none"/>
	<enumeration value="sum"/>
	<enumeration value="min"/>
	<enumeration value="max"/>
	<enumeration value="average"/>
	<enumeration value="count"/>
	<enumeration value="countNums"/>
	<enumeration value="stdDev"/>
	<enumeration value="var"/>
	<enumeration value="custom"/>
	</restriction>
</simpleType>