MS Project will not add data in Cost field

[Django]

Can anyone help me with the following problem? I have a column for cost, I
enter the data, however, MS Project will not add the data and provide a total
in the summary line. Appreciate any assistance in resolving this problem.

 

[John]

Can anyone help me with the following problem? I have a column for cost, I
enter the data, however, MS Project will not add the data and provide a total
in the summary line. Appreciate any assistance in resolving this problem.

Django,
Since you are entering the data I assume you are using a spare cost
field (e.g. Cost1). Project will only sum up data in spare fields if
that field is customized with a formula, and then only if the user
selects the option to sum up data for summary lines. Simply entering
data will not create a formula.

Off hand I can't think of any way to create a formula in the same field
where you want to enter data. However you can do what you want using two
spare cost fields. Enter your data in one field (e.g. Cost1). Customize
another spare cost field (e.g. Cost2) with a formula that simply equals
the value in Cost1. The formula and the option to sum up the data is set
using Tools/Customize/Fields.

Hope this helps.

John
Project MVP

 

[JulieS]

Django,
Since you are entering the data I assume you are using a spare cost
field (e.g. Cost1). Project will only sum up data in spare fields if
that field is customized with a formula, and then only if the user
selects the option to sum up data for summary lines. Simply entering
data will not create a formula.

Off hand I can't think of any way to create a formula in the same field
where you want to enter data. However you can do what you want using two
spare cost fields. Enter your data in one field (e.g. Cost1). Customize
another spare cost field (e.g. Cost2) with a formula that simply equals
the value in Cost1. The formula and the option to sum up the data is set
using Tools/Customize/Fields.

Hope this helps.

John
Project MVP

Just a quick clarification. In Project 2007 at least, you can select a
summary function (sum, min, max) for group or summary fields still
allowing the user to enter data into the subtasks. See Tools >
Customize > Fields.

I hope this helps.
Julie

 

[John]

Just a quick clarification. In Project 2007 at least, you can select a
summary function (sum, min, max) for group or summary fields still
allowing the user to enter data into the subtasks. See Tools >
Customize > Fields.

I hope this helps.
Julie

Julie,
Thanks for the clarification. When I responded I didn't have Project
open so I was going from memory. At least I "covered" myself by saying I
couldn't think of a way

John

 

[JulieS]

Julie,
Thanks for the clarification. When I responded I didn't have Project
open so I was going from memory. At least I "covered" myself by saying I
couldn't think of a way

John

John you have forgotten more about Project that I ever knew

 

[vip001]

Django wrote on 02/10/2010 21:26 ET

Can anyone help me with the following problem? I have a column for cost,
enter the data, however, MS Project will not add the data and provide a tota
in the summary line. Appreciate any assistance in resolving this problem

Djang

Product: MS Project 2007 OR 201
Steps
1. Change to Gantt Chart view mod
2. Display the cost colum
3. On any task item that also has a resource assigned, manually enter the tas
(Resource does not have a std or ovt cost in the resource sheet

Issues
1. cost correctly displays in Cash Flow - visual repor
2. cost does NOT display in Resource Cost summary - visual repor
3. If you update the std and ovt cost, the cost column does not update itsel
4. If you delete the manually entered cost, it remains "0" forever
does not update based on recalculatio

Request for assistance: Anyone else manually entered the cost and run int
similar problems? what is the fix? Only way i was able to resolve was t
re-create the whole task. That would be combersome if you have over 300 task
i
the plan.