CTSUM
Returns a number that represents the sum of a parent's child records.
CTSUM ( <field_name>, [<filter_query>] )
- field_name: The name of the field used to calculate the sum.
- filter_query: A query string representing the domain of records to include.
Example: creates a field on the CUSTOMER table that gives the sum of the products purchased by each customer in 1994.
CTSUM( [PRODUCT.PRODUCT_VALUE], [PRODUCT.PURCHASE YEAR] = "1994")