Search found 5 matches

by blusky_1010
Thu Mar 21, 2013 7:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Min, Max function in TM1
Replies: 5
Views: 8257

Min, Max function in TM1

Hi all! i have a trouble when i write the rules from Excel in TM1 i have 5 year like the Dimension below: https://plus.google.com/u/0/photos/111484833744603589373/albums/5856887200735562113/5856887200046051906?authkey=CMGx-oOkp5vOsgE and i want get Min in the row, if i used fomula Min(a,b,c) it have...
by blusky_1010
Thu Mar 21, 2013 3:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to write sum function
Replies: 5
Views: 3567

Re: How to write sum function

Hi Mr Alan Kirk! I do it work, but with my DimensionYear i must wire rules for one box, it that means i have to write 12 month * 5 year fomular, i would write alittle than more, can you give me a solusion for rules or re-designs my DimensionYear Thanks alot!! It should be possible to write a generi...
by blusky_1010
Wed Mar 20, 2013 8:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to write sum function
Replies: 5
Views: 3567

Re: How to write sum function

i have a cube with Dimension follow: i want to calculation ['DONGTHU','02.2013'] = sum ['DONGTHU' (02.2013----> END Of Row)] please help me! It appears that what you want is to calculate the sum of the "Year To Go"; that is, the sum of all months from the current one to the end of the yea...
by blusky_1010
Tue Mar 19, 2013 4:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to write sum function
Replies: 5
Views: 3567

Re: How to write sum function

i have a cube with Dimension follow: i want to calculation ['DONGTHU','02.2013'] = sum ['DONGTHU' (02.2013----> END Of Row)] please help me! It appears that what you want is to calculate the sum of the "Year To Go"; that is, the sum of all months from the current one to the end of the yea...
by blusky_1010
Tue Mar 19, 2013 3:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to write sum function
Replies: 5
Views: 3567

How to write sum function

i have a cube with Dimension follow:
https://plus.google.com/u/0/photos/1114 ... oOkp5vOsgE
i want to calculation ['DONGTHU','02.2013'] = sum ['DONGTHU' (02.2013----> END Of Row)]
please help me!
Thanks so much!