Custon Fields

M

Mitch

I'm a new user. I need to add a custom field that displays each task's
percentage of the total project cost. I figured out how to add the custom
field and write a formula, but I can't seem to be able to find how to enter
the project total cost in the formula.
 
J

Jack Dahlgren MVP

Sorry, custom fields can only reference their own values and a very limited
number of project fields. If you are using Project Server you can use the
enterprise project cost fields (and then have a formula for them), but
generally the answer is no you can't use a formula for this.

You can write a macro which could populate the value though

Sub mitch()
For Each Task In ActiveProject.Tasks
Task.Text1 = Left(CStr((Task.Cost / ActiveProject.ProjectSummaryTask.Cost) *
100), 4) & "%"
Next Task
End Sub

-Jack Dahlgren
 

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