Skip to main content
Version: Next

ACCUMULATE

ACCUMULATE ( data {; data2 ; ... ; dataN} )

ParameterTypeDescription
dataField, Variable🡒Numeric field or variable on which to accumulate

Description

ACCUMULATE specifies the fields or variables to be accumulated during a form report performed using PRINT SELECTION.

You must execute BREAK LEVEL and ACCUMULATE before every report for which you want to do break processing. These commands activate break processing for a report. See the explanation for the Subtotal command.

Use ACCUMULATE when you want to include subtotals for numeric fields or variables in a form report. ACCUMULATE tells 4D to store subtotals for each of the Data arguments. The subtotals are accumulated for each break level specified with the Subtotal command.

Execute ACCUMULATE before printing the report with PRINT SELECTION.

Use the Subtotal function in the form method or an object method to return the subtotal of one of the data arguments.

Example

See the example for the BREAK LEVEL command.

See also

BREAK LEVEL
ORDER BY
PRINT SELECTION
Subtotal