Cost Summation Error

[Laz]

Using MS Project Standard 2007, I have a 500 +/- line project plan with
several summary tasks. I developed the costs for each non-summary task and
would expect that the costs sum up to each summary task. Though this seemed
to be working I noticed the summary task costs did not always sum to what I
would expect.

I went thought the process of checking cost entry for ever row, they were
correct. Then I manually added the costs (I used and export to Excel). The
sums on the Excel spreadsheet were different then in Project and they were
the sums I was expecting.

How do make sure the calculations are correct?
Is there a recalculate function for the cost column in Project similar to
Excel? I looked but could not find it. Or is there perhaps a patch for MS
Project Standard 2007?

 

[Jim Aksel]

If the costs produced by Project at the summary level exceed what you are
getting from Excel, look to see if you have costed resources or other costs
(P2007) assigned to summary tasks.

Another instance I have seen (it was in P2003, however) was that if the
Earned Value Method for the summary tasks and each subodinate task has to be
the same. It didn't sum up correctly if the EV methods were different
(Advanced Tab on the Task Information Dialog).

I checked the Microsoft Connect site, the only other thing I found was here:
https://connect.microsoft.com/feedback/ViewFeedback.aspx?FeedbackID=250502&SiteID=235




--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[Jonathan Sofer]

Have you tried making sure that under Tools>Options your Calculations are
set to automatic?

You can always force re-cal using the F9 key as well.