Evaluates value
. If the value
is not a finite number, the function evaluates alternate
. Otherwise, the function returns value
.
This function is mostly intended to handle metrics that return NaN (not a number) when the data isn't available, such as Avg_pos
. However, you can also use the function to handle complex formulas that might return an infinite number.
Syntax
if_not_finite(value, alternate)
Parameters
value
and alternate
can be an expression, a number, or any Search Ads 360 variable that is a number.
You can nest this function to create an if, then, or else evaluation.
Example
Returns the "organic average position." If "organic average position" isn't available, Search Ads 360 reports NaN. In that case, the function returns "paid average position," or 0 if "paid average position" isn't available:
if_not_finite(Organic_avg_pos, if_not_finite(Paid_avg_pos,0))