Iif
Iif(cond, then, else) · Logic & variables
The simple if/else (compiles to SQL CASE WHEN). Both branches must share one type (SQX006).
Example
Section titled “Example”RevenueOrZero := Iif([Revenue] > 0, [Revenue], 0)Iif(cond, then, else) · Logic & variables
The simple if/else (compiles to SQL CASE WHEN). Both branches must share one type (SQX006).
RevenueOrZero := Iif([Revenue] > 0, [Revenue], 0)