Topic
This topic has been locked.
2 replies
Latest Post
 20130120T11:26:18Z by SystemAdmin
ACCEPTED ANSWER
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

ACCEPTED ANSWER
Re: Str function length argument
20130119T17: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.
Cheers!
Rizwan Kaif
ACCEPTED ANSWER
Re: Str function length argument
20130120T11:26:18Z in response to Rizwan.KaifThanks Rizwan,it is much clear now,Appreciate your help.
