The TSSum function returns a total for a numeric field. Conditions may be applied to limit which records are included in the total.
Syntax
TSSum( table name , field name , [ filter ] )
The TSSum function syntax has these parts:
| Value | Description |
|---|---|
| table name | Required. This argument identifies an SQL statement or a specific internal table name in the Sage 300 CRE Office database. If this argument does not supply a valid source of data, then the result of the function will be #TABLE? ("table name" not found). |
| field name | Required. This argument identifies an internal field name or alias returned by the table name argument. If this argument does not contain a valid field name, then the result of the function will be #FIELD? ("field name" not found). |
| filter | Optional. A filter is a string of text that includes comparisons between fields in the table and specific values. Only the records that satisfy the filter conditions will be used to return values. |
Example
Click here for examples.