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
" oris_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.