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 seven functions:
- Sum
- Returns the sum of the list elements.
- Average
- Returns the average of the list elements.
- Minimum
- Returns the minimum value.
- Maximum
- Returns the maximum value.
- Minimum Index
- Returns the list index containing the first occurrence of the minimum value.
- Maximum Index
- Returns the list index containing the first occurrence of the maximum value.
- Unicode String
- Returns a string representing the Unicode character values in the list. Empty and invalid list elements are ignored.
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 functions except Unicode String return 0.
When appropriate, 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.
