How to create an enterprise custom field that shows the project´s.

[Ignbell]

Hi,
Sorry if i create too many questions, i don´t know much about Project
Server.

I`m trying to create an enterprise grafical custom field that shows the
project´s situation Ex: On Target, Approaching Limit, Late, with diferent
simbols and colors.

I tried to use Lisa´s Formula but it get´s stucked on "on Target" and i
can´t save the formula because there´s a message telling me that my formula
has syntax error or is referring to an unrecognized function name or camp.

IIf(INT([Start]-date())>=5,"On Target",IIf(INT([Finish]-date())>5,Switch([%
Complete]<=100,"On Target"),IIf(INT([Finish])-date()>0 And
INT([Finish]-date())<=5,Switch([% Complete]<50,"Approaching Limit",[%
Complete]>50,"On Target"),IIf(INT([Finish]-date())=0,Switch([%
Complete]=0,"Late",[% Complete]>50,"Approaching Limit",[% Complete]=100,"On
Target"),Switch([% Complete]=100,"On Target",[% Complete]>25 And [%
Complete]<100,"Approaching Limit",[% Complete]<=25,"Late")))))

I don`t know if i shoul´d define somewhere "On Target" Value, tried to read
about formulas but i can`t enough information about it.

Thanks a lot.
Nacio.

 

[Ignbell]

It was my mistake, i had my Lists separator set to "."
Thanks all.