Data spreading a percentage

Post Reply
coop
Posts: 1
Joined: Wed Feb 10, 2016 2:55 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Data spreading a percentage

Post by coop »

Hi I am new to TM1 and struggling a little.
I have a budget cube which has sales and margin. It has the last two years data by product by week and I want users to input their suggested budget. To make it easier for them I want to get them to input at the total year level and have a data spread break back by week based on prior year. They then go in and adjust the phasing rather than having to build it all up by week in the first place. This was simple for Sales but when it comes to margin I want them to input the % rather than the cash, I have a rule to create the cash. The percents are adding up in the consolidations rather than being a division of the total cash. I can solve this with a rule but that means it isn't possible to put a percent in at total level because you can't input into a rule controlled cell. Is there anyway to get around this?
User avatar
Steve Rowe
Site Admin
Posts: 2464
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Data spreading a percentage

Post by Steve Rowe »

Can't you just create a new line "Margin % Input" for the users to enter data against and then use this to drive the calculation of costs and so on?
Technical Director
www.infocat.co.uk
Post Reply