Conditional functions

if

Returns one of two values based on a condition.

if(condition, value_when_true, value_when_false)

Example:

if(Revenue > 0, `Gross Profit` / Revenue, 0)

The three arguments are:

The two result expressions should represent compatible types. You can nest if calls:

if(Revenue > 100, "high", if(Revenue > 50, "medium", "low"))

For several categories or exceptions, a dimension-based formula may be easier to maintain than a deeply nested expression.