Indicator formulas

[ahelp]

We've created custom Enterprise Project Text fields called CPI Cue & SPI Cue.
They use the formulas CPI Cue = (CPI) & SPI Cue = (SPI). We want to display a
green indicator for CPI/SPI >/= 1, a yellow indicator for >/= .9, and a red
indicator for < .9.

For the tests, we used:
"is greater than or equal to" 1 for green
"is greater than or equal to" .9 for yellow
"is less than" .9 for red
We also tried "is within" .9,1 for yellow

We started with the "Nonsummary rows" radio button, but also tried "Project
summary" button with the same results.

The problem is that the indicator does not go to red until .2 for SPI & .5
for CPI. Perhaps there's a hole in my logic, as I tried the same tests for a
Number field and it just gave me an error. How should we set this up to get
the desired indicators?

Thanks,

 

[Geoff Vernon]

Hi Mike,

Use a Number custom field for your CPI Cue.

Use this formula:
IIf([CPI]>0.99,1,IIf([CPI]>0.89,2,3))

Set the graphical indicators to 1 equals Green icon, 2 equals Yellow icon, 3
equals Red icon.

This should do it for you.

Cheers......Geoff

 

[ahelp]

Hi Geoff,

Thank you very much! It works great (in both text and number fields). At
first it didn't appear to work at all. If I put the field in a project, it
was blank & when I put the cursor over it, it said Error! But after opening
and closing the Global Template and the project with which I was
experimenting a couple times, it mysteriously started working (I don't think
I made any changes - pretty bizarre). Bottom line--it works--I appreciate you
help!
--
Mike

Hi Mike,

Use a Number custom field for your CPI Cue.

Use this formula:
IIf([CPI]>0.99,1,IIf([CPI]>0.89,2,3))

Set the graphical indicators to 1 equals Green icon, 2 equals Yellow icon, 3
equals Red icon.

This should do it for you.

Cheers......Geoff

We've created custom Enterprise Project Text fields called CPI Cue & SPI Cue.
They use the formulas CPI Cue = (CPI) & SPI Cue = (SPI). We want to display a
green indicator for CPI/SPI >/= 1, a yellow indicator for >/= .9, and a red
indicator for < .9.

For the tests, we used:
"is greater than or equal to" 1 for green
"is greater than or equal to" .9 for yellow
"is less than" .9 for red
We also tried "is within" .9,1 for yellow

We started with the "Nonsummary rows" radio button, but also tried "Project
summary" button with the same results.

The problem is that the indicator does not go to red until .2 for SPI & .5
for CPI. Perhaps there's a hole in my logic, as I tried the same tests for a
Number field and it just gave me an error. How should we set this up to get
the desired indicators?

Thanks,

 

[Geoff Vernon]

My pleasure Mike... ;-)

Hi Geoff,

Thank you very much! It works great (in both text and number fields). At
first it didn't appear to work at all. If I put the field in a project, it
was blank & when I put the cursor over it, it said Error! But after opening
and closing the Global Template and the project with which I was
experimenting a couple times, it mysteriously started working (I don't think
I made any changes - pretty bizarre). Bottom line--it works--I appreciate you
help!
--
Mike

Hi Mike,

Use a Number custom field for your CPI Cue.

Use this formula:
IIf([CPI]>0.99,1,IIf([CPI]>0.89,2,3))

Set the graphical indicators to 1 equals Green icon, 2 equals Yellow icon, 3
equals Red icon.

This should do it for you.

Cheers......Geoff

We've created custom Enterprise Project Text fields called CPI Cue & SPI Cue.
They use the formulas CPI Cue = (CPI) & SPI Cue = (SPI). We want to display a
green indicator for CPI/SPI >/= 1, a yellow indicator for >/= .9, and a red
indicator for < .9.

For the tests, we used:
"is greater than or equal to" 1 for green
"is greater than or equal to" .9 for yellow
"is less than" .9 for red
We also tried "is within" .9,1 for yellow

We started with the "Nonsummary rows" radio button, but also tried "Project
summary" button with the same results.

The problem is that the indicator does not go to red until .2 for SPI & .5
for CPI. Perhaps there's a hole in my logic, as I tried the same tests for a
Number field and it just gave me an error. How should we set this up to get
the desired indicators?

Thanks,