NUMBR
NUMBR converts a string to a number.
This is a TM1® rules function, valid in both TM1 rules and TurboIntegrator processes.
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.
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.