STR
STR converts a number to a string.
This is a TM1® rules function, valid in both TM1 rules and TurboIntegrator processes.
The number passed to the STR function must use. (period) as the decimal separator and , (comma) as the thousand separator. Any other decimal/thousand separators will cause incorrect results.
Syntax
STR(number, length, decimal)| Argument |
Description |
|---|---|
| number |
The number being converted to a string. |
| length |
The length of the string. If necessary, the function inserts leading blank spaces to attain this length. |
| decimal |
The number of decimal places to include in the function result. |
Example
STR(3.14159, 6, 2) returns ' 3.14'.
STR(-3.14159, 6, 0) returns ' -3'.