** Customer Formula for a Custom Field **

[Tanya216]

I need help with a formula. I am not entirely sure I can do both, but here
is what I would like to do.

Formula variances for Project Health:
Green - Finish Variance <= Baseline Finish
Yellow - Finish Variance is within 0-10% of Baseline Finish
Red - Finish Variance > 10% of Baseline Finish

Once the formula is set for this custom field, how can I use the graphical
indicator to reflect the colors above. I hope this is not confusing. Any
help would be greatly appreciated.

 

[Jan De Messemaeker]

Hi,

I'm afraid it is confusing, sorry.
Finish Variance is a duration, say a number of days.
How can one compare say 10 days with 10/12/2008?

Wouldn't that rather be
Finish Variance <0
Finish variance 0-10% of project duration
else

So set Number1 to be
100* [Finish Variance] /ProjDateDiff( [Project Start] ;[Project Finish] )

* maybe with the American settings the ; is a , ??

then for the graphical indicators
is less then 0
is less than or equal to 10
is greater than 10

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf