Group Dollar Totals

[BillV]

Here is what I have: A group of jobs listed under their respective school
within a district (1-8) The totals for each school look good but, when you
look at the total for the District it is approximately twice the totals of
the combined school cost. Can anyone help me eliminate this problem. Here
is what it looks like:

i Loc Name Start Finish Board Member
Funding Project
Code
Source Budget

Local District 1
5,602,548.80


8726 Aggeler OP
896,577.41
Telephone Equip Replacement
24,900.56
Safety & Technology
751,069.85
LAN Modernization
120,607.00

2110 Anatola
992,073.58
PBX - Upgrade
6073.58
LAN Modernization
986,000.00

2117 Andasol
912,623.41
Routers
16,577.41
LAN Modernization
896,046.00


Allother information is filled in that's a given but; the Total in the Loca
District 1 line is twice that of what it should be. Only the totals directly
across from the school name should be added. Has anyone run into this
problem and does anyone have an idea on how to solve this issue.

Thanks,

Bill V

 

[John]

Here is what I have: A group of jobs listed under their respective school
within a district (1-8) The totals for each school look good but, when you
look at the total for the District it is approximately twice the totals of
the combined school cost. Can anyone help me eliminate this problem. Here
is what it looks like:

i Loc Name Start Finish Board Member
Funding Project
Code
Source Budget

Local District 1
5,602,548.80


8726 Aggeler OP
896,577.41
Telephone Equip Replacement
24,900.56
Safety & Technology
751,069.85
LAN Modernization
120,607.00

2110 Anatola
992,073.58
PBX - Upgrade
6073.58
LAN Modernization
986,000.00

2117 Andasol
912,623.41
Routers
16,577.41
LAN Modernization
896,046.00


Allother information is filled in that's a given but; the Total in the Loca
District 1 line is twice that of what it should be. Only the totals directly
across from the school name should be added. Has anyone run into this
problem and does anyone have an idea on how to solve this issue.

Thanks,

Bill V

Bill V,
Unfortunately the spacing of your columns in the post is so jumbled up I
can't tell what it what - at least that's how it looks on my newsreader.

I'll assume this is a question related to Microsoft Project, although
it's not obvious in either your description or the fields shown. We do
get a fair number of misguided posts in this newsgroup.

First question, what version of Project are you using?

Second question, I assume the "budget" column is the column where you
are having a problem. Which field is that in Project (i.e. Cost,
Baseline Cost, or some spare field so designated)?

Third question, do you have an data in the Fixed Cost field for any task
line?

John
Project MVP

 

[BillV]

Thanks fro responding John. I am using Project 2007 Professional not
connected to a server. The budget line is "Cost." Yes, Fixed cost is
entered for each subtask but not on the schools line and no entry on the
Local District Line.

 

[John]

Thanks fro responding John. I am using Project 2007 Professional not
connected to a server. The budget line is "Cost." Yes, Fixed cost is
entered for each subtask but not on the schools line and no entry on the
Local District Line.

Bill V,
Sorry for the slow response. I've got other "irons in the fire" right
now so I'm only able to spend a few minutes a day responding to
newsgroup issues.

I haven't used Project 2007 on a regular basis but I do know it has some
issues. Whether those issues are relevant to what you are seeing, I
don't know, but some of those issues have been addressed by the SP1
update. If you do not have that update installed, download it and
install it.

If you've already installed the update and still have a problem, it
would be a lot easier to understand your file structure if you could
e-mail it to me. As I mentioned in my original response, I can't make
heads or tails of the structure you posted. I don't really have time to
figure out what you "might" have done, but seeing your actual file may
result in a very quick solution. No guarantees, but that's my offer. Or
if somebody else has a good suggestion, please step in.

John
Project MVP
jensenljatatfastmaildotdotfm
(remove obvious redundancies)