Rule to avoid consolidation of total column

xiphiasjoe

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: 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;
&#91;'Total'&#93; = C: IF(ELLEV('calendarization',DB('calendarization',!account)) <> 0, 0, stet);

FEEDERS;
&#91;'Method'&#93;=>&#91;'Total'&#93;;

onelovely

I think you just mean:

Code: &#91;'Total'&#93; = C: IF(ELLEV('Account', !account) > 0, 0, stet);

315196952

Yes.. that worked.