how to summarize a custom Cost1 column

F

Fritz

I am trying to create a second Cost column with the ability to summarize automatically. I am not able to find the right tool. Any help would be appreciated.
 
J

Jack D.

Fritz said:
I am trying to create a second Cost column with the ability to summarize
automatically. I am not able to find the right tool. Any help would be
appreciated.


What summarization do you want to do?
The basic process is to go to the insert menu, select column and select the
column you want to insert.
Then right-click on that column and select "customize field"
There is a section in the dialog box which sets the "Calculation for task
and group summary rows" . Set it to sum.

If you want some other sort of summarization it is possible, but you have to
tell me what you want before I can tell you how to do it.

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently.
For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP
email: J -at- eM Vee Pee S dot COM


+++++++++++++++++++
 
F

Fritz

Jack, thanks a bunch ... I was looking at the dialog box and overlooked the option. Thanks again.
 
F

Fritz

OK ... it works with Project 2000 and up ... but I am not able to do it with MS Project 98 ... any thoughts
----- Jack D. wrote: ----

Fritz wrote
I am trying to create a second Cost column with the ability to summariz
automatically. I am not able to find the right tool. Any help would b
appreciated


What summarization do you want to do
The basic process is to go to the insert menu, select column and select th
column you want to insert
Then right-click on that column and select "customize field
There is a section in the dialog box which sets the "Calculation for tas
and group summary rows" . Set it to sum

If you want some other sort of summarization it is possible, but you have t
tell me what you want before I can tell you how to do it

--
Please try to keep replies in this group. I do check e-mail, but onl
infrequently
For Macros and other things check http://masamiki.com/projec

-Jack Dahlgren, Project MV
email: J -at- eM Vee Pee S dot CO


++++++++++++++++++
 
J

Jack D.

Upgrade to project 2000 or use visual basic.
You will need to take a summary task, loop through all the subtasks for that
task and sum their values, then put the result in the field that you want.
It isn't too hard, but it will be a macro and you will need to run it each
time you need the sum (it won't automatically update like the customized
field will)
OK ... it works with Project 2000 and up ... but I am not able to do
it with MS Project 98 ... any thoughts?
----- Jack D. wrote: -----

summarize > automatically. I am not able to find the right tool. Any
help would be > appreciated.


What summarization do you want to do?
The basic process is to go to the insert menu, select column and
select the column you want to insert.
Then right-click on that column and select "customize field"
There is a section in the dialog box which sets the "Calculation for
task and group summary rows" . Set it to sum.

If you want some other sort of summarization it is possible, but you
have to tell me what you want before I can tell you how to do it.

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently.
For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP
email: J -at- eM Vee Pee S dot COM


+++++++++++++++++++



--
Please try to keep replies in this group. I do check e-mail, but only
infrequently.
For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP
email: J -at- eM Vee Pee S dot COM


+++++++++++++++++++
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top