J
Jason-W
I'm trying to use Custom Enterprise fields on Project
Server 2003 to show stoplight budget indicators. There
are some problems I can't seem to work out. I made this
formula in the formula editor for Enterprise Project Text1:
Switch(Len(CStr([Baseline Finish]))<3,"No Baseline",
([Actual Cost]+1)/([Baseline Cost]+1)>1,"Overbudget",
([Actual Cost]+1)/([Baseline Cost]+1)>0.75,"75% Budget
Used",True,"Underbudget")
This is basically the same as the sample on page 164 of
the "MSP Server 2003 Application Configuration Guide," but
I turned off graphic indicators so I just get text. I
save it in the Enterprise Global Template and restart
Project Professional to reload the change locally. Then I
go onto the server, and setup a Project view with the
Enterprise Project Text1 field. All that appears are a
bunch of #Error messages. I tried republishing a copy
projects to see if it made a change, but the #Error keeps
showing up.
I'm not sure what's wrong so any help would be appreciated.
Thanks
Jason-W
Server 2003 to show stoplight budget indicators. There
are some problems I can't seem to work out. I made this
formula in the formula editor for Enterprise Project Text1:
Switch(Len(CStr([Baseline Finish]))<3,"No Baseline",
([Actual Cost]+1)/([Baseline Cost]+1)>1,"Overbudget",
([Actual Cost]+1)/([Baseline Cost]+1)>0.75,"75% Budget
Used",True,"Underbudget")
This is basically the same as the sample on page 164 of
the "MSP Server 2003 Application Configuration Guide," but
I turned off graphic indicators so I just get text. I
save it in the Enterprise Global Template and restart
Project Professional to reload the change locally. Then I
go onto the server, and setup a Project view with the
Enterprise Project Text1 field. All that appears are a
bunch of #Error messages. I tried republishing a copy
projects to see if it made a change, but the #Error keeps
showing up.
I'm not sure what's wrong so any help would be appreciated.
Thanks
Jason-W