Home > MultiValue Central > Online D3 Reference > Access: Verbs > access.total

access.total

Modifier/Access: Verbs, Releases: AP and R83

Summates columnar total.

Syntax

total attr.name {'total-limiter'} total attr.name {{operator} 'value.list'

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.

Example

list invoices total amount total amount (p
list invoices total status 'overdue'
list invoices total amount le '300' total amount gt '1000'

See Also

Command Name Type Description
access.roll-on Modifier creates a visual 'break' in output data when the value of a specified attribute changes, an improvement over the 'break-on' command.
access.modifiers Definition List of Access modifiers.
access.break-on Modifier Creates control break in Access reports.
access.det-supp Modifier Suppresses detail on Access reports.
access.attr.name Attribute Defining Item Specifies item(s) from the dictionary of the file.
access.grand-total Modifier Substitutes text for default '***' on grand total line.
pc.xr Processing Code Produce running sub-total

User Comments

What do you think?

Share your experience or ask a question by using the form below.

Login to leave your comments.