if_not_finite

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.

Note: This function is only available in Templates and can’t be used in Reporting.

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))

Related links

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
642183199533602619
true
Search Help Center
true
true
true
true
true
5055977
false
false