TM1 Forum

help in coding part;
String to numeric, the data will be entered as text and it should be converted into numeric and finally it should be calculated as average of it.


thanks and reagards,


tm1 9.5
excel 2007
windows vista

sreecharan wrote:help in coding part;
String to numeric, the data will be entered as text and it should be converted into numeric and finally it should be calculated as average of it.

After you (doubtless) read the Request For Assistance Guidelines, specifically the parts which say:

2) Ensure that you specify the component of the software that you're having a problem with. If someone states that they have a problem with number formatting, people need to know whether that's in Cube Viewer, Web, EV, or wherever.

(in this case, Rules or TI, either of which could be "the coding part" depending on how it's interpreted) and

5) Give a brief outline of what you've done to find the answer; which manuals or guides you've looked in, what tests you've done.

which manuals or help files did you look in, exactly?

sreecharan wrote:help in coding part;
String to numeric, the data will be entered as text and it should be converted into numeric and finally it should be calculated as average of it.

First of all as Alan said please follow the Request for assistance guidelines.

I will try to guess what you are looking for. If your data source has got data as text then in your TI Process you can use StringToNumber() to convert it to a number.

Then you can write a TM1 Rule to calculate the Average.

(my answer is based on assumptions as your question is not explanatory)

thank you

but this belongs to a requirement,
the requirement is like when you enter the data in a cube, the entered data will be text,
but in the report of the same cube,the text should be numeric.

thanks and regards

sreecharan wrote:but this belongs to a requirement,
the requirement is like when you enter the data in a cube, the entered data will be text,
but in the report of the same cube,the text should be numeric.

I don't know of any piece of software that can convert ABCDE into a number unless you are talking about the ASCII character codes. If you are talking about entering 12345, what makes you think TM1 would consider that text? Do you wiggle your left toe while hitting the number keys to indicate text and then wiggle your right toe to indicate a number? The answer, of course is neither. The determing factor as to whether it is text or a number is the cube design. If the spot in the cube you are sending to is configured to accept text then it will be text. If it is configured as numeric it will be numeric.