Decimal place in Physical% Complete

A

AnthemAZ

Is there any way to add decimals to the Phy% complete column?

This has a significant impact on high dollar tasks when calculating BCWP.
It's either round up to next or round down and that can be significant.

Thanks,

AnthemAz
 
D

Dale Howard [MVP]

AnthemAZ --

Sorry to disappoint you, but Microsoft Project always rounds off the
Physical % Complete value to the nearest integer. Hope this helps.
 
S

seribaginda

Add Decimal In Column - % Complete

Use this method :

1) Add column Text1 or Text2
2) Add Custom Field. Then add Formula below :
Format(([Actual Duration]/[Duration]),"0.00%")
3) Use Formula
4) Done.
5) But in Milestone column, #ERROR appears.
Don’t panic bro.
You can change all the duration = 0 to 0.1 or 0.01
and everything will be okay.

Just to share,
Silmi Zikay Planner
 

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