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.