ENFORM Reference Manual

Aggregates
ENFORM Language Elements
058057 Tandem Computers Incorporated 3–13
COUNT
is a predefined ENFORM aggregate that tallies the occurrences of a field defined
as either numeric or alphanumeric.
MAX
is a predefined ENFORM aggregate that finds the highest number in a set of
numbers or expressions, or finds the alphanumeric string with the highest value
based on the ASCII collating sequence.
MIN
is a predefined ENFORM aggregate that either finds the lowest number in a set of
numbers or expressions or finds the alphanumeric string with the lowest value
based on the ASCII collating sequence.
SUM
is a predefined ENFORM aggregate that totals a set of numbers or expressions.
user-aggregate
is the name of an aggregate defined by a DECLARE statement. (See Section 4).
field-name
is the name of a data base field.
expression
is a arithmetic or IF/THEN/ELSE expression (explained later in this section.)
over-item
is a field used to sort and group the records over which the aggregate is processed.
For a target aggregate, over-item must be a by-item (the name of a field modified by
a BY or BY DESC clause). For a qualification aggregate, over-item can be any field
name.
OVER ALL
defines the range of the aggregate operation as over all the values specified.