IF

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 but acts only on a single condition, and can return only one true result or one false result.

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. condition can be any valid Boolean expression.
• true_result - the value to return if condition is true. true_result can be any valid expression.
• false_result - the value to return if condition is false. false_result can 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)

Note: 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.

Related resources

• About calculated fields
• Looker Studio function list
• google/RE2 GitHub documentation