automated equal spread

Post Reply
User avatar
kwijibo
Posts: 15
Joined: Mon Aug 02, 2010 10:17 am
OLAP Product: TM1, Cognos Express
Version: [9.4.1] [9.5.1] [9.5.2] [10.1]
Excel Version: [2003] [2007]

automated equal spread

Post by kwijibo »

Hi,

is it possible to spread a value equally instead of proportionally?
I know that the standard spread method in e.g. TM1Web is the proportional spread - it spreads this way if entering a number without a data action.

Does anyone know if one can change this to equal spread?
It was perfectly if it was possible to enter a value at a consolidation and this is equally spread to its children.

If there exists a TI function like "CellPutProportionalSpread()", this would be a possibility too.
Any help is appreciated.

Regards
Nils
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: automated equal spread

Post by tomok »

Think outside the box. If you pre-populated the children with a value of 1, and then did a CellPutProportionalSpread, wouldn't that accomplish the same thing?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
kwijibo
Posts: 15
Joined: Mon Aug 02, 2010 10:17 am
OLAP Product: TM1, Cognos Express
Version: [9.4.1] [9.5.1] [9.5.2] [10.1]
Excel Version: [2003] [2007]

Re: automated equal spread

Post by kwijibo »

Thanks, already thought about that as a workaround.

However it would be very pleasant if that standard behaviour was changeable.
ndndon
Posts: 1
Joined: Thu Feb 27, 2014 4:47 pm
OLAP Product: tm1
Version: tm1
Excel Version: tm1

Re: automated equal spread

Post by ndndon »

Is there any update to this? I am facing the same issue.
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: automated equal spread

Post by tomok »

ndndon wrote:Is there any update to this? I am facing the same issue.
No.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply