S
Sumit
Hi,
I've created a nested formula which is running fine in a custom field of MS
Project 2007 but not when I add it to Enterprise Custom Field of Web Access
2007? Even in MS Project it is giving error. Do I need to do something diff
for enterprise custom field?
Following is the formula that I've used:
IIf([Baseline Finish]<>ProjDateValue("NA"),IIf([Baseline
Start]<Date(),IIf([% Complete]=100,IIf([Baseline
Finish]<=Date(),"Blue","Green"),IIf([Baseline Finish]<=Date(),IIf([%
Complete]>=90,"Green",IIf([% Complete]>=70,"Yellow","Red")),IIf(([%
Complete]/(((ProjDateDiff(Date(),[Baseline Finish]))/[Baseline
Duration])*100))>=0.9,"Green",IIf(([%
Complete]/(((ProjDateDiff(Date(),[Baseline Finish]))/[Baseline
Duration])*100))>=0.7,"Yellow","Red")))),"Green"),"NA")
Regards,
Sumit.
I've created a nested formula which is running fine in a custom field of MS
Project 2007 but not when I add it to Enterprise Custom Field of Web Access
2007? Even in MS Project it is giving error. Do I need to do something diff
for enterprise custom field?
Following is the formula that I've used:
IIf([Baseline Finish]<>ProjDateValue("NA"),IIf([Baseline
Start]<Date(),IIf([% Complete]=100,IIf([Baseline
Finish]<=Date(),"Blue","Green"),IIf([Baseline Finish]<=Date(),IIf([%
Complete]>=90,"Green",IIf([% Complete]>=70,"Yellow","Red")),IIf(([%
Complete]/(((ProjDateDiff(Date(),[Baseline Finish]))/[Baseline
Duration])*100))>=0.9,"Green",IIf(([%
Complete]/(((ProjDateDiff(Date(),[Baseline Finish]))/[Baseline
Duration])*100))>=0.7,"Yellow","Red")))),"Green"),"NA")
Regards,
Sumit.