Topic
  • 2 replies
  • Latest Post - ‏2013-01-20T11:26:18Z by SystemAdmin
SystemAdmin
SystemAdmin
658 Posts

Pinned topic Str function length argument

‏2013-01-19T06:37:18Z |
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
    Rizwan.Kaif
    197 Posts

    Re: Str function length argument

    ‏2013-01-19T17: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
  • SystemAdmin
    SystemAdmin
    658 Posts

    Re: Str function length argument

    ‏2013-01-20T11:26:18Z  
    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
    Thanks Rizwan,it is much clear now,Appreciate your help.