SUM

Returns a number that represents the sum of a parents child records.

SUM ( <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.

SUM( [PRODUCT.PRODUCT_VALUE], [PRODUCT.PURCHASE YEAR] = "1994")