TM1 Forum

When I create custom roll-ups for any dimension elements in TM1 Architect, first I ‘Insert Element’, than ‘copy’ and ‘Paste as child’ within it, other elements I want to be part of this roll-up.
After that, I define child elements ‘element weight’ from ‘Element Properties’:
• If I define element weight as ‘1’, it means element is added
• If I define element weight as ‘-1’, it means element is subtracted

Wondering, how we can do Multiplication or Division of roll-up sub-elements or if there is a way to build more complex formulas (besides subtraction and summation)?

Example: In the Chart of Account structure, I want to create user-defined rollup ‘Net Revenue Margin’, which is ‘EBITDA’ divided by ‘Net Revenue’. How can I do that?

Any help is appreciated! Thank you

You cannot do anything other than multiplication and it cannot be against another member, only a plain numerical value. Something like 1, 2, 5, .5, .001, etc. What you are asking for can only be done in rules.