Graphical indicator for %complete and duration

[rathan]

i want to display graphical indicator depending on the %completion
field value.For instance if the %Completion is less that 50% then the
stoplight should alert with RED.But here i have to consider the
duration(%duration).for instance if %completion is 20% when the
%duration is also 20% then its fine.But if duration% is 80% and
%completion is 30% the we should alert about this.what i need is can we
derive a formula and then based on the value we can display the
Stoplight.That is considering both %complete and duration-completed.
any suggesstions

 

[Rod Gill]

Yes you can do this by creating a formula in one of the custom fields. You
will need to use an if statement inside another If to create values "Red",
"Amber" and "Green". Then add graphical indicators to the same custom field
(Tools, Customize, Fields.) Don't have time to knock it up at the moment,
but it isn't too hard.