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