LessThan

aggregating category: comparison no `||`

Returns TRUE when each parameter is strictly less than the next.

Each value preceding another must be strictly less than the next for the rule to produce a TRUE result. At least two parameters must be given.

Parameters

N — values Mandatory — accepts: field, DATE, FLOAT, INT, STRING

The Nth value to compare against the next. May be a static value or a field reference.

Input type

• DATE
• FLOAT
• INT
• STRING

Output type

• BOOLEAN

Requires

• All values must have the same type.
• Two or more parameters must be given to the rule.

Examples

Three values

LessThan(:float1, :float2, 0.1)

Static followed by field

LessThan(12, :int)

See also

LessThanOrEqual, GreaterThan, GreaterThanOrEqual, Equal, NotEqual