Referencing the Baseline Work field

S

Shane

All,
I'm trying to create a calculated field that takes the contents of the
Baseline Work field and multiply by the Physcial % Complete field. The
formula is ([Baseline Work] * ([Physical % Complete]/100)). I get some
screwball number, so to verify the contents of the Baseline Work
field, I created a custom field (Baseline0Work) that just references
that field, ([Baseline Work]). The number in the Baseline0Work field
does not match what shows in the Baseline Work field. In fact, for one
task, the Baseline Work field shows 6256 and the Baseline0Work field
shows 375360. What's going on ?!?!?!?!?
 
S

Shane

6256 X 60 = 375360

Project stores Work in units of minutes.  Divide everything by 60 and you
should be good.

- Andrew Lavinsky
Blog:http://blogs.catapultsystems.com/epm


All,
I'm trying to create a calculated field that takes the contents of the
Baseline Work field and multiply by the Physcial % Complete field. The
formula is ([Baseline Work] * ([Physical % Complete]/100)). I get some
screwball number, so to verify the contents of the Baseline Work
field, I created a custom field (Baseline0Work) that just references
that field, ([Baseline Work]). The number in the Baseline0Work field
does not match what shows in the Baseline Work field. In fact, for one
task, the Baseline Work field shows 6256 and the Baseline0Work field
shows 375360. What's going on ?!?!?!?!?- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Andrew,
Thanks. Perfect answer. The calculation works.
 
Top