Formula : Project Server 2007

A

Alain

Hello, I am using Project Server 2007 B2 TR. I have try to enter a formula
for an project and task custom field. I would like to display budget and
schedule indicator for the project and for each task. It seems there is a bug
because, when I enter the following formula :
--------------------------
Switch(Len(CStr([Baseline Finish]))<3,"No baseline",ProjDateDiff([Baseline
Finish],[Finish])/480>=5,"Late by more than 5 days",ProjDateDiff([Baseline
Finish],[Finish])/480>0,"Late",True,"On schedule")
--------------------------
then I saved it and try to reopen the custom field, my formula changed to :
--------------------------
Switch(Len(CStr([MSPJ188743724]))<3;"No
baseline";ProjDateDiff([MSPJ188743724];[MSPJ188743716])/480>=5;"Late by more
than 5
days";ProjDateDiff([MSPJ188743724];[MSPJ188743716])/480>0;"Late";True;"On
schedule")
--------------------------
Moreover the graphical indicators remain empty in the view that are using
these custom fields.

Any idea to solve this issue ?

Thanks.
 

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