About totaling fields

You can total numeric fields or expressions in the active table. Totaling finds the arithmetic sum of one or more numeric fields, and is typically used to prove the completeness and accuracy of the data, and to produce control totals. The results are displayed in the ACL display area.


Some character fields, such as invoice numbers, may contain numbers. To total this type of data, create a computed field that uses the VALUE( ) function to convert character data to numeric data, and then total the computed field.

Related tasks
Totaling fields
Related reference
VALUE( ) function

(C) 2015 ACL Services Ltd. All Rights Reserved.