SumSelection ("filename.expression", searchExpression)

Result Type: Number

Definition: Returns the sum of the nominated expression (which should be numeric) for the nominated searchExpression for the specified filename. Note that both parameters must be in quotes. When summing detail lines, use the SumDetail function.


SumSelection("transaction.gross-amtpaid", "type = \"DII\"")

Returns the sum of all outstanding invoices (including unposted).

SumSelection("Name.dbalance", "D90Plus > 0")

Returns the total outstanding for all debtors who have invoices over 90 days old.

SumSelection("Name.dbalance-dcurrent", "DBalance > D.Current")

Returns the total overdue for all debtors with overdue amounts.

See Also:

CreateSelection: Create a selection of records

DisplaySelection: Display standard list window for a given selection of records

IntersectSelection: Intersect a selection with the result of another search

RecordsSelected: Count records in a selection or resulting from a (meta) search

SumDetail: Add up a field for details matching a search

UnionSelection: Add the result of another search to a selection