Description

Conditional return

Syntax

IF(n1, v2, v3)

·        n1: numeric (Boolean value)

·        v2: return value if n1 is non-zero

·        v3: return value if n1 is zero

Example

IF(IS NULL(Desc), “???”, Desc)         If Desc is NULL  ® “???”

                                                      Otherwise                ® Desc

Note

Do not compare a Boolean field to its TRUE value, just use it as the value. In other words: IF(field, v2, v3) rather than IF(field=TRUE, v2, v3)