Download User Reference Guide - MSC Fileman 22.2 Documentation

Part 4: Computing Data
MSC Fileman 22.2 User Reference Guide
from the current file or Multiple.
Use:
This function returns the value for the field identified by
field in the previous entry. The previous entry is
determined by internal entry number. No analysis of the
value of entries is done. If there is no prior entry, the
function returns null.
Example:
PREVIOUS(AGE AT ONSET) => 29 [the value of AGE
AT ONSET for the prior entry in the Subfile]
TOTAL
Format:
TOTAL(fname)
TOTAL(fname:field)
Parameters:
In the first format, fname is the name of a file or of a
Multiple-valued field in your current file.
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]
Mathematical Functions
ABS
Format:
ABS(n)
Parameters:
n is a number or an expression with a numeric value.
January 2015
181