Roll-up Costs within Group

[BillV]

I need some help badly. In my schedule I have a column that depicts Cost
called Project Budget. Each School is the Summary task with the actual jobs
being done as the subtasks. When grouped within the district each school
shows the total cost. However, on the District line it shows approximately
twice the amount that should be on the line. So in essence it's counting all
subtask costs and the total at the school and adding them together. I will
send anyone my Project Schedule, this is really critical as this is supposed
to go to print today! - Thus I need the help.

Thanks,

 

[Mike Glen]

Hi Bill,

Welcome to this Microsoft Project newsgroup

One of the common reasons for doubling costs is where you have resources
assigned to tasks and the same resources assigned to the summary. You might
like to check that.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[Jan De Messemaeker]

Hi Bill,

Tried this on a very small file and it shows that when grouping with the
option Show Summary tasks (as is necessary for your view) , there is a bug
and indeed cost is counted twice. I'll try to find a workaround.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Jan De Messemaeker]

Hi,

OK, here's the workaround.
You wil have to do some work yourself though..

Replace your current Project Budget Column with the Cost1 field
Select any cell in this column
Tols, Customize, Fields, it now presents Cost
Rename, Project Budget
Custom Attributes, click the word Formula
In the formula window, click Field, then Cost, then Fixed Cost
Colculation for group... select Rollup, Sum
OK

There you are.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[BillV]

Jan, you are a genius! If you are ever in the LA area let me know, I at
least owe you a big dinner.

Thanks