Example Code from MS doesn't work?

[Mark Langendoerfer]

This code is from the Sample site that ships with Project Server 2003. And
the white indicator shows #Error. I looked at the sample site and it gives
the same #Error. Anyone know what the problem is?

Switch(Len(CStr([Baseline Finish]))<3,"No baseline",([Work]+1)/([Baseline
Work]+1)>1.2,"Overbudget by 20% or more",([Work]+1)/([Baseline
Work]+1)>1,"Overbudget",True,"Under budget")

 

[JackD]

It works for me. Is there a baseline set for the task? If not then you would
expect to get an error.
-Jack

 

[Mark Langendoerfer]

I was under the impression that it was supposed to show the white indicator
if there was no baseline saved?

Switch(Len(CStr([Baseline Finish]))<3,"No baseline",

It works for me. Is there a baseline set for the task? If not then you would
expect to get an error.
-Jack

This code is from the Sample site that ships with Project Server 2003. And
the white indicator shows #Error. I looked at the sample site and it gives
the same #Error. Anyone know what the problem is?

Switch(Len(CStr([Baseline Finish]))<3,"No baseline",([Work]+1)/([Baseline
Work]+1)>1.2,"Overbudget by 20% or more",([Work]+1)/([Baseline
Work]+1)>1,"Overbudget",True,"Under budget")

 

[JackD]

Hmm...

That isn't the test I'd use for no baseline.

Try this sort of test instead:

Switch([baseline finish]>50000, "No Baseline",

You can find out why this test works at my website:

http://masamiki.com/project/customfieldFAQ.htm

-Jack

I was under the impression that it was supposed to show the white indicator
if there was no baseline saved?

Switch(Len(CStr([Baseline Finish]))<3,"No baseline",

It works for me. Is there a baseline set for the task? If not then you would
expect to get an error.
-Jack


message news:[email protected]...

This code is from the Sample site that ships with Project Server 2003. And
the white indicator shows #Error. I looked at the sample site and it gives
the same #Error. Anyone know what the problem is?

Switch(Len(CStr([Baseline Finish]))<3,"No baseline",([Work]+1)/([Baseline
Work]+1)>1.2,"Overbudget by 20% or more",([Work]+1)/([Baseline
Work]+1)>1,"Overbudget",True,"Under budget")

 

[Brian K - Project MVP]

This code is from the Sample site that ships with Project Server 2003. And
the white indicator shows #Error. I looked at the sample site and it gives
the same #Error. Anyone know what the problem is?

Switch(Len(CStr([Baseline Finish]))<3,"No baseline",([Work]+1)/([Baseline
Work]+1)>1.2,"Overbudget by 20% or more",([Work]+1)/([Baseline
Work]+1)>1,"Overbudget",True,"Under budget")

Try thisone:
IIf([Baseline Finish]=ProjDateValue("NA"),"No baseline",IIf(ProjDateDiff
([Baseline Finish],[Finish])/480>=5,"Late by more than 5 days",IIf
(ProjDateDiff([Baseline Finish],[Finish])/480>0,"Late","On schedule")))