This topic has been locked.
2 replies Latest Post - 2013-01-20T11:26:18Z by SystemAdmin
Pinned topic Str function length argument
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 2013-01-20T11:26:18Z at 2013-01-20T11:26:18Z by SystemAdmin
Rizwan.Kaif 27000219XW197 PostsACCEPTED ANSWER
Re: Str function length argument2013-01-19T17:41:03Z in response to SystemAdminBarrysb,
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.