MoneyWorks Manual
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