The total modifier accumulates a columnar total for a specified attribute-defining item.
If the total modifier is used in the same sentence as a roll-on, subtotal values are generated whenever a break occurs. The subtotal displays in the appropriate column for each attribute specified in a total modifier. At the end of the listing, a total is generated for each column. In computing the value for accumulation, correlatives (attribute 8) are processed, but conversions (attribute 7) are applied to the totaled value.
Syntax
total attr.name {"total-limiter"} total attr.name {operator} "value.list" |
Parameter(s)
total-limiter |
Functions like the value string portion of the selection criteria process, limiting totals to values that pass the specified selection criteria. |
attr.name |
Name of the attribute whose values are to be totaled. |
operator |
Any legal relational operator, such as =. If no operator is specified, = is assumed. |
value.list |
List of values to match, enclosed in double quotation marks or backslashes. |
Example(s)
list invoices total amount total amount (p |
list invoices total status "overdue" |
list invoices total amount le "300" total amount gt "1000" |