4D Doc Center : Sum

4D v12.4

Sum


Sum ( series ) -> Function result

Parameter	Type	Description
series	Field	Data for which to return the sum
Function result	Real	Sum for series

Description

The Sum command returns the sum (total of all values) for series. If series is an indexed field, the index is used to total the values.

If the command is correctly executed, the OK system variable is set to 1. If it is interrupted (for example if the user clicks on the Stop button of the progress thermometer), the OK variable is set to 0.

Example

The following example is an object method for a vTotal variable placed in a form. The object method assigns the sum of all salaries to vTotal:

vTotal:=Sum([Employees]Salary)

The following method is called to print the records in the selection and to activate break processing:

 ALL RECORDS([Employees])

 ORDER BY([Employees];[Employees]LastNm;>)

 BREAK LEVEL(1)

 ACCUMULATE([Employees]Salary)

 OUTPUT FORM([Employees];"PrintForm")

 PRINT SELECTION([Employees])

Note: The parameter to the BREAK LEVEL command should be equal to the number of breaks in your report. For more information about break processing, refer to the printing commands.