Available Functions
This section lists functions available for calculations.
Some functions exist in two variants ('name' and 'name_', for example 'gt' and 'gt_'). The variant functions differ in their ability to handle null values:
- 'name' functions return a null value if any of their arguments is null. This may cause problems e.g. if the output feeds an 'IF' function, which expects boolean values as its arguments. For this reason, 'name_' functions are provided.
- 'name_' functions also handle null arguments, a null argument is considered as the smallest value of all. Thus these functions always return a boolean value.
|