TM1 TI How to trim out extra space from text
Posted: Mon Feb 06, 2017 1:14 pm
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.
Please help.
Code: Select all
X4 = '15';
Tnum = ROUND(Tnum);
S0 = EXPAND('%X' | EXPAND('%Tnum%') | '%');