type (aggregate)

The type property in the Aggregate category defines how the aggregate field value is computed.

This property is available only when the aggregate property is selected.

PROGRAM specifies that the aggregate value is computed and displayed by the program code.

An aggregate type different from PROGRAM specifies that the aggregate value is computed automatically:

  • SUM computes the total of all values of the corresponding numeric column.
  • AVG computes the average of all values of the corresponding numeric column.
  • MIN displays the minimum value of the corresponding numeric column.
  • MAX displays the maximum value of the corresponding numeric column.
  • COUNT computes the number of rows.

The SUM and AVG aggregate types apply to data types that can be used as operand for an addition, such as INTEGER, DECIMAL, INTERVAL.

The MIN and MAX aggregate types apply to data types that can be compared, such as INTEGER, DECIMAL, INTERVAL, CHAR, DATETIME.

For additional information, see the AGGREGATETYPE attribute topic in the Genero Business Development Language User Guide.