Sum Including Zeros

Syntax

Sum Including Zeros

Parameters

None.

Description

Used with the Sum command to force a calculation even if some of the fields contain a zero value (either a numeric zero or a time of 0:00:00).

Remarks

By default, Sum assumes a zero value represents an incomplete event and will not calculate a total. This command overrides that behavior.

Examples

Field               POINTS1
Sum
Field               POINTS2
Sum
Field               POINTS3
Sum
Field               TOTAL
LARGEST             2
Sum Including Zeros