Logical Functions

Conditional statements that use IF THEN ELSE or CASE WHEN THEN formulations return values or metric expressions depending on whether specific conditions are met.

IFNULL allows you to substitute a predefined replacement value in a report, if a null value is returned.

For details about individual conditional statements, see the following sections: