Indicator Formulas

[Jay]

Hi. I am trying to set a Finish Variance to show with stoplight indicators. I
can get the formula to work for greater than 20 days (red), 10 to 20 days
(yellow), and so on.

I need the formula to work for percentages though. For instance, if the
Finish Variance is greater than 20%, then red. Does anyone know the proper
formula in the Graphical Indicator section to set?

 

[Gary L. Chefetz [MVP]]

Jay:

20% of what? Think about this and tell us what you really want to measure.
Keep in mind, for instance, that a task can be a year late but not
completely within its planned duration and work. It could even be under its
baseline for these. You many need to challenge your stakeholders who are
driving this requirement.

--

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

 

[Wilt Thomas Rovira Britton]

Hi, Jay.
I'm using this formula to calculate some %variations:

This is an example for some Enterprise custom fields (Number):
Formula: IIf(ProjDateValue("NA")=[Baseline Start] Or [Baseline
Duration]=0,-8888,[Duration Variance]/[Baseline Duration])

-8888 = No baseline or duration=0