NUMBR
NUMBR converts a string to a number. The string passed to the NUMBR function must use. (period) as the decimal separator and , (comma) as the thousand separator. Any other decimal/thousand separators will cause incorrect results.
This function is valid in both TM1® rules and TurboIntegrator processes.
Syntax
NUMBR(string)
Argument |
Description |
---|---|
string |
The string you want to convert to a number. All characters other than '0' through '9', '+', '-', '.', and 'E' are ignored. |
Example
NUMBR('-5.6') returns -5.6.
NUMBR('-5A. B6C') returns -5.6.