TM1 Forum

Hi:

I am training to learn TM1 so this question is quite basic.

I am creating a simple P/L statement with Net Profit equal to Sales minus Costs as you'd expect.

I have created a dimension with Net Profit as the overall parent of both Sales and Costs. Sales has several children, as does Costs, (but then they are children as well?)

This is what I am looking to achieve:

Net Profit (PARENT) £800 (I want TM1 to calculate this)
Sales (Child of Net Profit) £1100
Costs (Child of Net Profit) £300

Sales (PARENT) £1100 (Can TM1 Calculate this?)
License sales (Child of Sales) £1050
Support (Child of Sales) £50

Costs (PARENT) £300 (Can TM1 calculate this?)
Wages (Child) £200
Rent and Rates (Child) £100

I know I will need to weight Wages and rents as -1.0, but it gives me the option of also entering a weight for "Costs" Shouldn't it know this?

Any guidance on how to achieve this is greatly appreciated.

Thank you,

You can either weight everything as 1 and load/enter costs as a minus number.

Or if you load everything as a positive number:
If you entered Wages & Rent as positive numbers you would also want to show "costs" as a positive number as it is purely the sum of those 2.
The first and only 1 in your example where I would use a negative weight is to deduct "costs" from "sales" in order to get your "net profit".

compilersaysyes wrote: I know I will need to weight Wages and rents as -1.0, but it gives me the option of also entering a weight for "Costs" Shouldn't it know this?

In TM1 an element can be both a parent and a child of other elements (as with most consolidation tools); the relationship it has to it's parent is completely independent from that of it's relationship with it's children.
The best thing for you to do as a way of learning would be to just start throwing in weightings and seeing what impact it has on the consolidations.

Consolidations in TM1 are like a SUM formula in Excel. Weightings are a way to flip signs of cells inside the SUM. Simple as that. Like Declan said, the easiest thing for you, since you are still learning, is going to be be to experiment. It's stupid easy to change so try it different ways and then pick the way you want. There is no right or wrong answer as long as the totals are what you want them to be.

thank you both.
kind regards,