SPI Enterprise Custom Field

[mm]

I am looking for help creating a formula where SPI
"is greater than or equal to" 1 for Green
"is between .90 and .99" for yellow
"is less than or equal to" .89 for red

Thanks

 

[NZ Projects]

Create a new task/text field and enter the following formula

IIf([SPI]>=1,"Green",IIf([SPI]>0.9,"Amber","Red"))

 

[mm]

Thanks,

What would the addition be to handle yellow

Create a new task/text field and enter the following formula

IIf([SPI]>=1,"Green",IIf([SPI]>0.9,"Amber","Red"))

I am looking for help creating a formula where SPI
"is greater than or equal to" 1 for Green
"is between .90 and .99" for yellow
"is less than or equal to" .89 for red

Thanks

 

[GirlGeek]

Thanks,

What would the addition be to handle yellow

Create a new task/text field and enter the following formula

IIf([SPI]>=1,"Green",IIf([SPI]>0.9,"Amber","Red"))

I am looking for help creating a formula where SPI
"is greater than or equal to" 1 for Green
"is between .90 and .99" for yellow
"is less than or equal to" .89 for red
Thanks- Hide quoted text -

- Show quoted text -

I think by 'amber' he meant 'yellow'

 

[mm]

Thanks This works great however the graphical indicators will not display on
the summary tasks in the project. When I put the mouseover it the value is
there just not the graphic but it should on the lowest level tasks.

Any ideas would be appeciated.

Create a new task/text field and enter the following formula

IIf([SPI]>=1,"Green",IIf([SPI]>0.9,"Amber","Red"))

I am looking for help creating a formula where SPI
"is greater than or equal to" 1 for Green
"is between .90 and .99" for yellow
"is less than or equal to" .89 for red

Thanks

 

[mm]

I created another enterpise field with the same formula and it works fine.

Thanks

Thanks This works great however the graphical indicators will not display on
the summary tasks in the project. When I put the mouseover it the value is
there just not the graphic but it should on the lowest level tasks.

Any ideas would be appeciated.

Create a new task/text field and enter the following formula

IIf([SPI]>=1,"Green",IIf([SPI]>0.9,"Amber","Red"))

I am looking for help creating a formula where SPI
"is greater than or equal to" 1 for Green
"is between .90 and .99" for yellow
"is less than or equal to" .89 for red

Thanks