TM1 TI How to trim out extra space from text

Post Reply
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

TM1 TI How to trim out extra space from text

Post by Ashleigh W »

Hi everyone, How to trim out extra space from text. Below code 'm expecting to return X4 but it returns "X 4.000" and error log show variable not found.
Please help.

Code: Select all

X4 = '15';
Tnum = ROUND(Tnum);
S0 = EXPAND('%X' | EXPAND('%Tnum%') | '%');
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: TM1 TI How to trim out extra space from text

Post by tomok »

What about the ROUNDP function?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
mykill
Posts: 11
Joined: Thu Jun 26, 2008 12:07 pm
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2010
Location: Germany

Re: TM1 TI How to trim out extra space from text

Post by mykill »

Code: Select all

NumbertoString(Tnum);
should work.
Post Reply