3305 Main Street Ste 019 Vancouver, WA 98663

TSSum Function

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 Timberline 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.