Formula working in MS Proj but not in Web Access 2007

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.
 
R

Rod Gill

Which Enterprise field did you add it to, and what's working differently
from the original field which was?

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: www.projectvbabook.com
 
S

Sumit

Hi Rod,
I had created an Ent Custom Field in Web Access and saved it... The issue
was when I created it in MS Project for testing purpose... it showing
indicators while when i added it to Web Access then I was getting error. I
just refreshed after 15 minutes and the indicators showed up.

The problem is resolved.

Thanks & Regards,
Sumit.

Rod Gill said:
Which Enterprise field did you add it to, and what's working differently
from the original field which was?

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: www.projectvbabook.com


Sumit said:
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.
 

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