Please help me to check this formula. Why for milestone task, the graphic indicator did not show?

IIf(CDbl([Baseline Finish]>60000)," Not Baseline",IIf(([Baseline Duration]=0 Or [Duration]=0),Switch([% Complete]=100," Completed",[Status Date]<[Start]," Not Start Yet",[Status Date]>[Start],"Late"),Switch([Status Date]<[Start]," Not Start Yet",[% Complete]=100,"Completed",(ProjDateDiff([Start],[Status Date])/480)/Val(ProjDurConv(Duration,pjDays))*100<=[% Complete],"Ahead Schedule",(ProjDateDiff([Start],[Status Date])/480)/Val(ProjDurConv(Duration,pjDays))*100>[% Complete],"Late")))

  • More information is needed. To start: 1) What field contains this formula? 2) What did you expect to see in that field? 3) What did you actually see instead? – Rachel Hettinger Sep 10 at 17:26
  • The field contain this formula is text field. What I expect to see is it show graphic indicator for the case " Not Start Yet", "Completed", " Ahead Schedule" or " Late". What my actual saw is for the normal task which already started it work well, but other normal task which have not start yet and milestone task it does not work – Thach Sep 11 at 4:55

With a slight modification to the formula it works without error for the milestones. Be sure to check the graphical indicators set up to be sure the text matches--your formula has a space before two of the values: " Completed", " Not Start Yet".

Here's the updated formula which changes a < to <= in the first Switch statement ([Status Date]<=[Start])

IIf(CDbl([Baseline Finish]>60000)," Not Baseline",IIf(([Baseline Duration]=0 Or [Duration]=0),
Switch([% Complete]=100," Completed",[Status Date]<=[Start]," Not Start Yet",[Status Date]>[Start],"Late"),
Switch([Status Date]<[Start]," Not Start Yet",[% Complete]=100,"Completed",(ProjDateDiff([Start],[Status Date])/480)/Val(ProjDurConv(Duration,pjDays))*100<=[% Complete],"Ahead Schedule",(ProjDateDiff([Start],[Status Date])/480)/Val(ProjDurConv(Duration,pjDays))*100>[% Complete],"Late")))
  • Thank you. It worked well already – Thach Sep 12 at 0:37

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.