Need help with feeders!

Post Reply
Maxon
Posts: 13
Joined: Thu Jun 03, 2010 8:44 am
OLAP Product: TM1, Transformer
Version: TM1 9.5
Excel Version: 2007

Need help with feeders!

Post by Maxon »

Can u help me?
There are calculations:
['090100']=N:STET; C:(['090100','11']*['090092','11' ] +['090100','12']*['090092','12'])\['090092','10'];
['090101']=N:STET; C:(['090092','11']*['090101','11']+['090092','12']*['090101','12'])\['090092','10'];
['090102']=N:STET; C: ['090104']\['090092'];
How write feeders for calculations?
User avatar
wissew
Posts: 54
Joined: Tue Jun 17, 2008 7:24 pm
OLAP Product: TM1
Version: 9.5.2; 10.2.2; 11
Excel Version: 2003 SP3 - 2013
Location: Beaverton, OR

Re: Need help with feeders!

Post by wissew »

Feeders are not required for C: level rules. If there is not n level data is will not calc.
Maxon
Posts: 13
Joined: Thu Jun 03, 2010 8:44 am
OLAP Product: TM1, Transformer
Version: TM1 9.5
Excel Version: 2007

Re: Need help with feeders!

Post by Maxon »

There are #N/A in quaterly total.
Why?
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: Need help with feeders!

Post by David Usherwood »

Change your divides from / to \ . This gets rid of errors when the denominator is zero.

And as a general comment to posters - don't assume that all problems are feeder related. Feeder problems are manifested by seeing correct calculations at base level which do not consolidate and disappear when zero suppressing views.
Post Reply