Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference MIN
Functions and Expressions Reference Guide
152
MID ("abc123", -1 , 3) returns NONE because argument2 is a
negative number.
MID ("abc123", 2 , -2) returns NONE because argument3 is a
negative number.
Uses
Use
MID when you need specific characters from a text item.
Related Functions
FIND, LEFT, RIGHT
MIN
The MIN function returns the minimum value from a series.
Syntax
MIN (series-item-expression)
Meaning
MIN (series_of_which_to_find_min)
Returns
This function returns a single-number.
The result is the minimum value of the input series: number, text, or
date/time.
Examples
MIN (UnitPrice:Input)
If the values for UnitPrice are {20,10,100}, MIN returns 10.
MIN (StartTime:.:Schedule)
Returns the minimum (earliest) StartTime in Schedule.