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


History

VersionStatusNotes
10.0UpdatedCarried over from Panorama 6.0, but no longer requires omega symbol at end of field name.