Rule to avoid consolidation of total column

[schia00]

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?

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'];

[Andy Key]

I think you just mean:

Code: Select all

['Total'] = C: IF(ELLEV('Account', !account) > 0, 0, stet); 

[schia00]

Yes.. that worked.