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

Function Field

MINMIN (minimum) is a special type of field usage assigned to the function fields containing the result of a computation of the lowest value for a particular field.

The MIN field usage uses a special built-in routine that computes the value of the function field based on the input parameter. For instance, within an Edit Transactions function type, you define a MIN function field on the header record file to calculate the lowest value of orders appearing in the detail file. You must define the input and result parameters associated with the MIN function field. The MIN function field calculates the resultant value on initialization and call to the function.

MIN function fields have two, and only two, parameters:

• A result parameter—This is the summed MIN function field itself. You must place this field on the totaling format of any CA 2E function (Display Transactions or Edit Transactions) that calls the MIN function field.
• An input parameter—This specifies the field for which MIN determines the lowest value. This field must be present on the detail record format of the calling function.

Function fields of usage MIN must always be numeric. If the function field is defined as a referenced (REF) field based on another numeric field, CA 2E assumes that the based-on field is the field whose minimum value is calculated.