SubTotal (columnName)

Result Type: Number

Definition: Only available in forms.

Returns the total of all numbers printed in the named column of a list for the current record. The column must contain numeric data. ColumnName should be a string of the form: "listname.columnName". You must name the list using the List Options command so that you can refer to it.

You must set the Always Calculate check box for a calculation that uses the SubTotal function, since the value of the function will be different for each page of a multi-page form.

Examples:  SubTotal("myList.Column2")

returns the current subtotal for the column whose result name is “Column2” in the list named “myList”.

See Also:

ExpandDetail: Expand form search result values to a parameter list

ExpandList: Expand form list values to a parameter list