VA FileMan V. 22.0 Getting Started HTML Manual Banner

 

Contents: Main Chapter See Also: Getting Started Manual Programmer Manual

VA FileMan Functions

TOTAL

Format:
  1. TOTAL(fname)
  2. TOTAL(fname:field)
Parameters:
  1. In the first format, fname is the name of a file or of a Multiple-valued field in your current file.

  2. In the second format:

    • fname is the name of your current file or Multiple.

    • field is the name of a field (or a field number preceded by #) in fname.
Use: With the first format, this function totals the values of the .01 field of a Multiple or file identified by fname. The second format totals the values in field. The field being totaled must have numeric values.
Example: "$"_TOTAL(VISIT COST)=> $569.32 [VISIT COST is a Multiple]

 

Reviewed/Updated: March 4, 2007