Author Topic: TM1 Calculations  (Read 9721 times)

Offline dbaker21

  • Associate
  • **
  • Join Date: Jun 2008
  • Posts: 4
  • Forum Citizenship: +0/-0
TM1 Calculations
« on: 17 Nov 2008 02:50:45 pm »
Where are Calculations entered in TM1?
I want to calculate the Variance between years.
I have 06 Actuals and 07 Actuals and 06-07 Variance
How do I calculate, within a cube to have 06-07Actuals = 07 Actuals - (Minus) 06 Actuals
I tryed this in the "Expression window" and always came up with an error!

Thank you
DB

Offline dusherwo

  • Community Leader
  • *****
  • Join Date: Jan 2009
  • Posts: 81
  • Forum Citizenship: +6/-0
Re: TM1 Calculations
« Reply #1 on: 09 Jan 2009 09:01:16 am »
There are two ways to do what you want. By far the most efficient is to set 06/07 Variance to be a parent of 06 Actuals and 07 Actuals, and make the consolidation a subtraction by changing the weight of 06 Actuals to -1.

For more complex calculations, you write rules. These are attached to cubes (right click and select 'Create Rule'). The rules language is very powerful but (probably therefore) easy to mistreat. Generally I don't like recommending to posters to take a course as it can seem a bit of a brushoff but in this case it probably makes sense. The more recent versions of TM1 have a rules guide in PDF form which would get you started.