A script-enabled browser is required for this page to function properly.

Function property

The Function property specifies the computation to be performed on the values of the summary column specified in the Source property. To create running summaries, you place the column in the appropriate group and use the Function propertyin conjunction with the Reset At property.

Applies to

Summary columns

Values

Average

Calculates the average of the column's values within the reset group.

Count

Counts the number of records within the reset group.

First

Prints the column's first value fetched for the reset group.

Last

Prints the column's last value fetched for the reset group.

Maximum

Calculates the column's highest value within the reset group.

Minimum

Calculates the column's lowest value within the reset group.

% of Total

Calculates the column's percent of the total within the reset group.

Std. Deviation

Calculates the column's positive square root of the variance for the reset group.

Sum

Calculates the total of the column's values within the reset group.

Variance

Sums the squares of each column value's distance from the mean value of the reset group and divides the total by the number of values minus 1.

Default

Sum

Required/Optional

Required, if column is a summary column. 

Restrictions