Re: Calculated Field Expected % Complete Error

The formula contains a lot of division by [Duration2] which is likely to be 0 for a milestone.

It looks like you need to embed the whole formula in something which describes behaviour for the case where that happens:

Text1 = IIf( [Duration2]=0 , <describe behaviour for milestones> , <embed John's formula from below> )

I haven't checked these details but the division by 0 is the starting point for me.

Rob wrote:
I have project 2007 pro-not using server.

I have used the formula from John below to get an expected/scheduled % complete calculation but get #ERROR in Text1 Field for Milestones.

Any Ideas?

Thanks for your help.

*****

It will just take 3 custom fields instead of one. Here's the basic outline of the process.
1. Create three custom fields (e.g. Text1, Duration1, and Duration2)
2. At the task level use the following formulas:
Text1=IIf([Duration1]/[Duration2]>=1,"100%",IIf([Duration1]/[Duration2]=0
,0,format([Duration1]/[Duration2],"#.00%")))
Duration1=IIf(projdatediff([Baseline Start],[Date1])>[Baseline Duration],[Baseline Duration],IIf(projdatediff([Baseline Start],[Date1])<=0,0,projdatediff([Baseline Start],[Date1])))

Duration2=[Baseline Duration]

3. At the summary level use "rollup - sum" for Duration1 & Duration2
4. At the summary level "use formula" for Text1


John
Project MVP

*****

.