LOOKUP
Basic Overview
Description  Performs an approximate match lookup in a onecolumn and returns the corresponding value from another onecolumn 

Signature  LOOKUP('Node1', 'Node2', 'Node3', [DefaultReturnValue], [LevelName]) 
Parameters 

Limitations  Important: The values in the index must be placed in ascending order (alphabetical sorting), otherwise, LOOKUP might not return the correct value

Example
Lookup Value:
Employee  Salary 

E1  50.000 
Index:
Sequence  Threshold 

0  0 
1  10.000 
2  30.000 
3  60.000 
Return Value:
Sequence  Tax 

0  0 
1  0 
2  1.000 
3  2.000 
4  3.000 
LOOKUP(lookup_value, index, return_value)
Employee  Tax 

E1  1.000 
Expanding the Sequence Dimension
The sequence dimension is a default dimension that defines the steps of a time value. In rare cases, it can be helpful or even necessary to edit the sequence dimension to support complex scenarios on a monthly level. Additional info on the sequence dimension and how to modify it can be found at: Configure the Sequence dimension .