Topic
Pinned topic Str function length argument
20130119T06:37:18Z

Answered question
This question has been answered.
Unanswered question
This question has not been answered yet.
The Str function length argument is Str(Boss,12,8),could gurus clarify me that 12 is entire length and 8 is decimal point.Should we count the number from left to right or other way around and includes the decimal point.Thanks
Updated on 20130120T11:26:18Z at 20130120T11:26:18Z by SystemAdmin

Re: Str function length argument
20130119T17:41:03ZThis is the accepted answer. This is the accepted answer.Barrysb,
The syntax of STR() which you have mentioned in your post is not correct. The correct syntax is:
STR(number, length, decimal)
where number is what you want to convert to String
length is the total number of digits in the number (excluding decimal point and it start from left to right)
decimal is number of decimal places to include as the result of this function.
The detail on these simple TM1 functions is available in the TM1 manuals. Please refer to the manual before posting.
Cheers!
Rizwan Kaif 
Re: Str function length argument
20130120T11:26:18ZThis is the accepted answer. This is the accepted answer. Rizwan.Kaif
 20130119T17:41:03Z
Barrysb,
The syntax of STR() which you have mentioned in your post is not correct. The correct syntax is:
STR(number, length, decimal)
where number is what you want to convert to String
length is the total number of digits in the number (excluding decimal point and it start from left to right)
decimal is number of decimal places to include as the result of this function.
The detail on these simple TM1 functions is available in the TM1 manuals. Please refer to the manual before posting.
Cheers!
Rizwan Kaif