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
automated equal spread
-
- 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
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?
- 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
Thanks, already thought about that as a workaround.
However it would be very pleasant if that standard behaviour was changeable.
However it would be very pleasant if that standard behaviour was changeable.
Re: automated equal spread
Is there any update to this? I am facing the same issue.
-
- 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
No.ndndon wrote:Is there any update to this? I am facing the same issue.