Graphical Indicators Formulas

T

Tom

I need to calculate some formulas and graphical indicators
and am having no such luck.

I have two goals Duration and finish variance

I would like duration if < 90 to be green >90 to be red.
I would like the finish variance to be green if < 15 and
red if > 15.

Can someone help me with formula

Thank you,
Tom
 
R

RLynn

Tom, Here are the steps I would take to accomplish this.

1.Open Enterprise Global and create custom fields (1 for
Duration & 1 for Finish Variance)Do steps 2-10 for each
field changing "Duration" to "Finish Variance".
1a. Type = Duration for the Duration custom field
1b. Type = Number or Text for Finish Variance
2.Select "Fomula"
3.Using the "Field" drop-down select "Duration" and click
OK.
4.Select "Graphical Indicator"
5.In the 1st row select "less than" from the drop-down
6.Enter 90 in "value" and select and image from
the "image" drop-down.
7.In the next row enter "greater than" from the drop-down
and enter 90 in "value".
8.Click OK
9.Save and close Project
10.Reopen project and insert a column (the custom field)
in your view. You should see your graphical indicator.

Note: If you want this to appear in PWA you need to insert
a column in the view, open the project, and then save it.
In PWA change or create a view to display the custom field.

Hope this helps.
RLynn
 
Top