is_not_finite

is_not_finite determines if a number is finite and returns true or false.

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

Syntax

is_not_finite(value)

Parameters

value: value should be a number.

Examples

  • is_not_finite(1) = "False" or is_not_finite(abc) = "True"
  • Alternatively, this could be used to avoid values that would be divided by 0 (which would be infinite). For example, if(is_not_finite(price/quantity),0, price/quantity * 10)
    • If the price was divided by "0" quantity, that would give us an infinite number. In this formula, if that occurs, we return a value of "0". If the number is finite, we divide price or quantity and multiply by 10.

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
4539259248343038102
true
Search Help Center
true
true
true
true
true
5055977
true
false