Search found 3 matches
- Wed Jan 20, 2010 2:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performing YTD and other relative time calculations in TM1
- Replies: 13
- Views: 15533
Re: Performing YTD and other relative time calculations in TM1
this post helped me get YTD consolidating in the period dimension following your screenshots. Thank you!!! I am still interested in learning how to do it in a rule (although I understand the pro's and con's) because before we were trying to do it as another measure element like the period balance in...
- Tue Jan 19, 2010 11:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules for Cumulative running Totals
- Replies: 9
- Views: 11262
Re: Rules for Cumulative running Totals
hey I was able to get it done on the dimension ... this post helped me understand what I needed to do http://forums.olapforums.com/viewtopic.php?f=3&t=1936 ... thanks a lot for the reply Paul.
- Mon Jan 18, 2010 3:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules for Cumulative running Totals
- Replies: 9
- Views: 11262
Re: Rules for Cumulative running Totals
Hey guys ... I am new to TM1 and I am trying to replicate my balance sheet in TM1. What I am having a problem doing is creating a column for the YTD balance with is a sum of the balance of all the periods up to where you are. I have tried a million ways and in the latest iteration I am getting an N/...