Customizing Fields and calculations

[Bud]

I created a custom field for Revenue.

It's a simple calculation of 70*Actual_Work. However, actual work has the
hrs designator in their so in order for this calculation to be correct I have
to use another field and take the hrs designator out of the field.

Is there any way to use Actual work the way it is with the hrs designator in
their with the formula. I don't want to have to create a whole new field than
remove the hrs designator for this simple calculation.

Thanks

 

[Jim Aksel]

A custom field such as Cost1 or Text1 works just fine.
Insert a Cost1 field (column). Right click on it.
Select Customize Fields
Select Formula
70*[Acutal Work]/60

Why the 60? Work is stored in minutes by MS Project, it may be displayed
differently but is stored in minutes. So, a conversion is needed and will
change depending on the units displayed in the Actual Work column. A more
robust solution would be possible if you tested on the units for display and
then picked your coversion accordingly.
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

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