MoneyWorks Manual
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.
Examples:
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