Application icon

List Numeric Functions

This function performs numeric operations on a list. If a list element starts with a numeric value it will be used, otherwise zero will be assumed. Note that negative numbers and numbers with fractions are supported.

The function essentially has three operating modes:

Source in track variable, result to track variable
Each file is processed as a separate entity. Each source track variable contains a list and each destination track variable receives a result. List elements are separated by a specified delimiter.

Source in named variable, result to named variable
The source named variable contains the list and the destination named variable receives the result. List elements are separated by a specified delimiter.

Source in track variable, result to named variable
Each track variable is treated as being a single list item. The destination named variable receives the result. There is no delimiter as each source track variable is a list item.

Text fields may contain any of the escape sequences described in Escape Sequences. Note when running stepwise escape sequences are evaluated only once based on the first file's field values.

There are six functions: Sum, Average, Minimum, Maximum, Minimum Index and Maximum Index. The Index functions return the index of the specified value. The index functions are invalid when the source is in track variables and the destination is in a named variable. If a list is empty all of the functions return 0.

You can specify a post operation to limit the result to an integer value. The possibilities are None (fractional results may be returned), Round, Truncate, Floor and Ceiling.