Percent complete in the MSP_EpmTask table

[AndyS]

Hi

Could someone please explain the differences between three percent complete
fields in the MSP_EpmTask table in the Reporting Database. The three fields
that I see are:

TaskPercentWorkCompleted
TaskPhysicalPercentCompleted
TaskPercentCompleted

I wish to use the data in earned value reports.

Thanks in advance

Andy

 

[Gérard Ducouret]

Hello Andy,

- TaskPercentWorkCompleted : in Project Pro : % Work Complete, Percent of
*Work* complete (can be calculated by Project)
- TaskPhysicalPercentCompleted : in Project pro : Physical % Complete.
Entered by the user. Can be used to bias the calculation of Earned value.
In Tools / Options / Calculation Click the Earned value button : Project
propose the choice between % Complete and Physical % Complete to calculate
the EV.
- TaskPercentCompleted : In Project Pro : % Complete, Percent of *Duration*
complete (can be calculated by Project)

You can find an exhaustive definition of these fields in The Help of Project
Professional

Hope this helps

Gérard Ducouret

 

[AndyS]

Thanks Gérard for your quick reply.

That's exactly what I was looking for.

Kind regards

Andy

 

[Gérard Ducouret]

You are welcome Andy,
Thanks for the feedback!

Gérard Ducouret