Referencing the Baseline Work field

[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 ?!?!?!?!?

 

[Andrew Lavinsky]

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

 

[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 -

- Show quoted text -

Andrew,
Thanks. Perfect answer. The calculation works.