sum(
sum(
FIELD
)

The sum( function adds up all instances of a line item field in the current record.

Parameters

This function has one parameter:

field – is the line item field you want to add up. This must be a numeric field, not text. You may use the Ω symbol (type option-Z) at the end of the field name to indicate that the fields to be added are line items, however, that is not required. The field name may be quoted, but that is not required.

Description

The sum( function adds up all instances of a line item field in the current record. For example, `Sum(QtyΩ)` will add up all `Qty1+Qty2+Qty3+...` for as many line items fields are in the database. The *sum(* function has two advantages over simple addition: 1) it’s easier to type, and 2) it automatically adjusts if additional line item fields are added to (or removed from) the database.

This example adds up the Amount line item fields, Amount1+Amount2+Amount3+… .

    sum(AmountΩ)

or

    sum(Amount)

This formula adds up the Tax line item fields.

    sum("TaxΩ")

See Also

- count( -- counts all non-empty instances of a line item field in the current record.
- emptylineitemnumber( -- returns the numeric suffix of the first matching line item field that is empty (if any).
- Line Item Fields -- are used for repeating items within a record

History

Version | Status | Notes
10.0 | Updated | Carried over from Panorama 6.0, but no longer requires omega symbol at end of field name.