none
HOW TO CALCULATE PLANNED % COMPLETE? RRS feed

  • Question

  • Appreciate your time to look into the formula that i am using and assist to overcome error occur at milestone which caused by zero duration divide by zero.

    1. Number 1
    Val(ProjDurConv(Duration,pjDays))

    2. Number2
    IIf(ProjDateDiff(Start,[Status Date])/480>=Val(ProjDurConv([Baseline Duration],pjDays)),Val(ProjDurConv([Baseline Duration],pjDays)),IIf(DateDiff(“d”,[Baseline Start],[Status Date])=Val(ProjDurConv([Baseline Duration],pjDays)),Val(ProjDurConv([Baseline Duration],pjDays)),IIf(DateDiff(“d”,[Baseline Start],[Status Date])<=0,0,ProjDateDiff(Start,[Status Date])/480))

    3. Number3.
    Number2/Number1

    4. Text2
    Format(Number3,"0%")

    Sunday, July 28, 2019 4:28 AM

All replies

  • Try the following:

    IIf(Number1=0,0,Number2)


    Tanzim Akhtar

    Sunday, July 28, 2019 1:22 PM
  • Try the following:

    IIf(Number1=0,0,Number2)


    Tanzim Akhtar

    Hi, Tanzim,

    Thanks for your reply.

    Where this formula shall put into?

    Friday, August 16, 2019 3:17 AM
  • Hello BenLau,

    In Number3 you should put the following formula:

    IIf(Number1=0,Number2/Number1)
    This will take care of the error in sha' Allaah.


    Tanzim Akhtar

    Sunday, August 18, 2019 5:39 AM
  • Hello BenLau,

    In Number3 you should put the following formula:

    IIf(Number1=0,Number2/Number1)
    This will take care of the error in sha' Allaah.


    Tanzim Akhtar

    Hi, Tanzim,

    I tried the formula as per your recommendation.

    Now the number 2, which named as "% planned" shown more than 100%.

    Sunday, August 18, 2019 7:19 AM