IIF statement problem

[scot.milroy]

Hi guys,

I am having an issue with an IIF statement. I have setup stoplight
indicators but there are four indicators as listed below:

Greater than 15d - RED
Less than 15d - Yellow
Od - Green
Less than 0d - Green Happy Face

I am having calculating this based the Finish Variance but all of the
formulas come out either Red or Yellow. Is there a way I can fix this
so that is calculates correctly for each of the four variables above.

Thanks,

Scot

 

[Dale Howard [MVP]]

Scott --

I believe you should set up the tests as follows:

Greater than 15d Red
Greater than 0d Yellow
Equals 0d Green
Less than 0d Green Smiley Face

The way that you set up your second test is the cause of your problem.
Project Server determines each stoplight indicator by processing your list
of tests and stops processing when it gets its first "hit" (true result).
Your second test was returning yellow for everything less than 15 days,
including 0 days and less. Hope this helps.

 

[scot.milroy]

Is there a way to include in the IIF statement for the second test if
the Finish Variance falls between 1 and 15? I can't figure out the
statement.

Thanks,

Scot

 

[scot.milroy]

Never mind about my last post. I didn't read the beginning of your
message.

Thanks again.

Scot