SUM

Description

The SUM function calculates the sum of all non-blank values in a subform's field or in two or more fields.

Usage

SUM(VALUE1, VALUE2, VALUE3, ...)
SUM(SUBFORM_FIELD.FIELD_NAME)

Remarks

When used with subform fields, the argument to SUM() must include a reference to the form's subform field and then the field within the subform, using the dot notation.

The SUM function only accepts numeric or boolean arguments.

For the purpose of averaging logical values, TRUE values are treated as 1.0 and FALSE values are treated as 0.0.

Examples

Calculating a total project budget from subrecords

If you have a Projects form, with a subform containing the cities where the project is being implemented, and each city has its own budget, you might want to sum all of the individual budget lines to find the project's total budget using a formula like:

SUM(CITIES.BUDGET)

If you have a project with the following subrecords:

City Country Budget
Kinshasa DRC 10,000
Goma DRC 5,000
Gisenyi Rwanda 5,000

Then the result of SUM(CITIES.BUDGET) would be 20,000.

Summing multiple fields in the same form together

You can also use SUM to add together multiple fields. For example, if you have an activity report form with four quantity fields: WOMEN, MEN, GIRLS, BOYS and you wanted the total number of people reached, you could write:

SUM(WOMEN, MEN, GIRLS, BOYS)

The formula above has the same result as using the + operator:

WOMEN + MEN + GIRLS + BOYS
Next item
SUMMARIZE