Returns a value based on a conditional expression.
IF defines a condition and returns a result when that condition is met, or returns a different result if that condition is not met.
Note: IF is similar to CASE
Sample usage
Calculate a bonus rate if actual sales exceed forecast sales:
IF(Actual > Forecast, Bonus *1.2, Bonus)
Syntax
IF(condition, true_result, false_result)
Parameters
condition- The expression to evaluate.conditioncan be any valid Boolean expression.true_result- the value to return ifconditionis true.true_resultcan be any valid expression.false_result- the value to return ifconditionis false.false_resultcan be any valid expression.
Examples
Return a dimension based on a parameter selection.
For example, you can create a Boolean parameter, Forecast Parameter, and use it to return a column of forecasted data. Otherwise, use the actual data:
IF(Forecast Parameter, Forecast Data, Actual Data)
Identify records that are older than a certain number of days before today:
IF(DATETIME_DIFF(TODAY(), Date, DAY) > 60, "old","new")
A more complex condition with logical AND, and regular expression matching:
IF(Event name = "purchase" AND (REGEXP_MATCH(Page path, ".*footwear.*") OR REGEXP_MATCH(Page path, ".*shoes.*")), "Shoe Sales", Page title)
IF is limited to returning only one of two possible results: the true_result or the false_result. To create a function that can return more possible results, use CASE or simple CASE instead.