TM1 Forum

Hi All,


I built a report initially as an active form to be used in conjunction with the Tm1 print report function. I was told they no only needed a total but also a check, the list of consolidators on the rows are not consistent, i.e they aren't all the same level ( some are level 2 some are level 3 or 4)


doing a total in active form is no problem but doing the check, that's when things move around.
example

consol1
consol2
consol3
Subconsol1
Subconsol2
consol4
consol5
consol6
consol7
subconsol3
Total consol


Check ( total consol - sum of all subconsols) should equal zero

how do I do this?

I need to use the print report as they redo this report between different regions. and suppression is important


Thank you for your help!

Hello knightowl,

I would first consider a parallel hierarchy in your dimension, with 1 consolidated element, containing all the levels levels to be tested.
These elements roll up in the new total with weight 1 or -1. You can immediately get the value at the consolidated value (which should be zero).
You can choose to include the total element in your active form (if the total is really 0 it would be suppressed).
Or you add the total ("error") in a separate cell at the top of the report, in red font.