Stoplight indicators and no baselines defined

[kwwatson]

The is a really nice "How do I create stoplight like those used in the
project server sample database"

Which can be found @
http://www.projectserverexperts.com/shared documents/createstoplightindicators.htm

I have one question thou, how do I modify the directions to include an
indicator for no baseline. I tried setting it to Finish variance equal
to 0 but that did not work.

 

[Gary L. Chefetz [MVP]]

Kevin you can test for no baseline this way:

[Baseline Finish]=projdatevalue("NA")

 

[kwwatson]

Gary,

Thanks for getting back on the issue.

Sorry the light bulb is just not lighting up for me.

I still am not sure how I am to incorporate the test you have given me
to the directions provided in the above link. Does the formula you gave
have to be modified and if so how. You simply used "Finish Variance" to
calculate the different values outlined in the graphical Indicators. I
want to be able to add to the test, one for no baseline, right now the
values come up with 0. There is no "NA"

Thanks

..

 

[kwwatson]

Gary,

Thanks for getting back on the issue.

Sorry the light bulb is just not lighting up for me.

I still am not sure how I am to incorporate the test you have given me
to the directions provided in the above link. Does the formula you gave
have to be modified and if so how. You simply used "Finish Variance" to
calculate the different values outlined in the graphical Indicators. I
want to be able to add to the test, one for no baseline, right now the
values come up with 0. There is no "NA"

Thanks

..

 

[Gary L. Chefetz [MVP]]

Kevin:

You need to write a formula using the test in an IFF statement. The FAQ
outlines a different approach.