Status stoplight indicator setup

[303588]

Greetings,
Setting up a status indicator view using stoplights. Can't get it to
work. We only update tasks via PWA % complete, not with hours worked
per day. The logic I have been given is as follows ....

Bottom Task Level
1) If task =100% complete - GREEN.
2) If task <100% and Baseline Finish is > 30 calendar days away -
GREEN.
3) If task <100% but >50% and Baseline Finish within 30 calendar days
- GREEN.
4) If task <50% and Baseline Finish within 30 calendar days - YELLOW.
5) If task <100% and Baseline Finish date has past - RED.
The task level status should roll up to each Summary level task.

Overall Project and Summary Level Tasks
A rollup of the bottom level tasks with the same criteria for color
code.

Any help with the formula would be appreciated.

Thanks,

Sam Baker
FedEx Express Business Systems

 

[Gary L. Chefetz [MVP]]

Sam:

What are you trying to measure here? Finish Date variance? The steps for
doing this is to create a new custom enterprise task field and write a
formula that returns the variance values and exception states you want to
detect, such as the task has no baseline. Then you set the graphical
indicators to display based on value returned by the formula. First, you
need to clean up your logic, the statements below are fuzzy and fail to
consider the range of possible data states you must test for and resolve.
For instance is a task always green because it's 100% complete, even though
it finished 3 months late? That's the way it's written below.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com