Syntax:
ifn({<data>})
Return:
Data. Returns the first non-null data among
multiple data/expressions.
Parameter <data>:
Original value/original expression. Usually multiple parameters used together, i.e., number of parameters >= 1. Required parameter; type is simple data type; parameter name omitted.
Example:
Take the first non-null value among "",
null, "Class 3".
NLC snippet: ifn("",null,"Class 3") // returns "".