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.