access.total Modifier/Access: Verbs

access.total

Command access.total Modifier/Access: Verbs
Applicable release versions: AP, R83
Category Access: Verbs (152)
Description accumulates a columnar total for a specified attribute-defining item.

The optional "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" is the name of the attribute whose values are to be totaled.

"operator" is any legal relational operator, such as "=". If no operator is specified, "=" (equal) is assumed.

"value.list" is a list of values to match, enclosed in (") (double quotes) or "" (backslashes).

If the "total" modifier is used in the same sentence as a "roll-on", subtotal values are generated whenever a break occurs.

The subtotal is displayed 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"
Options
Example
list invoices total amount total amount (p
list invoices total status "overdue"
list invoices total amount le "300" total amount gt "1000"
Purpose
Related access.roll-on
access.modifiers
access.break-on
access.det-supp
access.attr.name
access.grand-total
pc.xr