Rule to avoid consolidation of total column
Posted: Thu Mar 01, 2012 8:08 pm
Hello! I'm new to TM1 so this might just be a simple question to you.
I have two dimensions: accounts (row) and values (col). The last column is a Total column. In this last column, I want to consolidate the data on leaf-level accounts, but avoid consolidation on non-leaf level accounts (consolidation on accounts). In the image attached I want to have a rule or conditional feeder to remove the consolidation identified in the red box. How can I go about this?
I have two dimensions: accounts (row) and values (col). The last column is a Total column. In this last column, I want to consolidate the data on leaf-level accounts, but avoid consolidation on non-leaf level accounts (consolidation on accounts). In the image attached I want to have a rule or conditional feeder to remove the consolidation identified in the red box. How can I go about this?
Code: Select all
SKIPCHECK;
[{'P01','P02','P03','P04','P05','P06','P07','P08','P09','P10','P11','P12'}] = N: IF(DB('calendarization',!account,'Method') @= 'Equal',1/12,stet);
C:0;
['Total'] = C: IF(ELLEV('calendarization',DB('calendarization',!account)) <> 0, 0, stet);
FEEDERS;
['Method']=>['Total'];