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.


TSSum( table name , field name , [ filter ] )

The TSSum function syntax has these parts:

table nameRequired. 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 nameRequired. 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).
filterOptional.  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.


Click here for examples.