Minimum Version Required: 23.01
Pre-Conditions
Required Permission - FusionEdit
Recommended Fusion I/II Certification
Steps
If Value1 is NULL, returns Value2, otherwise returns Value1.
Syntax
IFNULL(Value1,Value2)
Arguments
Value1:
The value you want to see unless it is NULL.
Value2:
The value you want to see if Value1 is NULL.
Example
IFNULL(1,2) = 1
IFNULL(NULL,2) = 2