Configure Conditional expression
Functions
COALESCE
| Syntax | COALESCE(exp1,exp2,...exp(n)) |
| Description | Returns the first non-NULL expression among its arguments or NULL if all its arguments are NULL. |
| Example | COALESCE(3+NULL, 2*NULL, 5*2*7) |
IF
| Syntax | IF(expression, true_part, false_part) |
| Description | Returns either the true part or the false part, depending on the evaluation of the expression. |
| Example | IF([CustomerID]='VINET' AND [OrderID]='10248', [Discount], [Discount]+0.1) |
ELSE IF
| Syntax | IF(expression,1,IF(expression,0,1)) |
| Description | Returns either the true part or the evaluated if expression in the false part, depending on the evaluation of the expression. |
| Example | IF([id] >5,1,IF([id] <5,0,1)) |
IFNULL
| Syntax | IFNULL(expression1, expression2) |
| Description | Returns expression1 if the expression1 evaluates to be not null. |
| Example | IFNULL([ShipRegion],'Region not specified') |
ISNOTNULL
| Syntax | ISNOTNULL(expression) |
| Description | Returns true if the given expression evaluates to be not null. |
| Example | ISNOTNULL([ShipRegion]) |
ISNULL
| Syntax | ISNULL(expression) |
| Description | Returns true if the given expression evaluates to null. |
| Example | ISNULL([ShipRegion]) |