Defining Functions › Function Types, Message Types, and Function Fields › SUM Function Field

SUM Function Field

The Sum function field is a special field usage used within functions to contain the result of a computation of the sum of values of another field.

Function fields of type SUM must be numeric. If the function field is defined as a reference (REF) field that is based on another field, the SUM field contains a summation of the values of the referenced field. The referenced field must also be numeric.

Function fields of type SUM always have two parameters:

• A result parameter: This is the actual field itself containing the results of a summation. You must place the field on a totaling format or subfile control format of the Display or Edit Transaction that calls the SUM function field.
• An input parameter: This is the field whose sum will be calculated. This field must exist on the detail format of the function using the SUM function field.

The following are examples of Sum fields:

• Total order value: the sum of order lines
• Total warehouse space: sum of location space