less than

syntax

• lt(a, b)
• a < b

definition

lt(a, b) or a < b results in a boolean data item indicating if the values of data item a are less than the values of data item b.

description

Each comparison with missing values results in the value false.

applies to

Data items with value types:

• group: Numeric
• string
• bool

conditions

Data items a and b need to match with regard to their:

• value type
• metric
• domain unit (constants or parameters can be used in comparisons with data items of each domain unit)

since version

5.15

example

1. attribute<bool> AltB (CDomain): expr = "lt(A, B)";    
2. attribute<bool> AltB (CDomain): expr = "A < B";

A	B		AltB
0	0		False
1	2		True
2.5	2.5		False
-100	100		True
999	-999		False
null	0		False
null	null		False
0	null		False
null	100		False
100	null		False

Table CDomain, nr of rows = 10

see also

• less than or left side has null values