Microsoft Office Tutorials and References
In Depth Information
Reporting project cost variance with a stoplight view
The Number3 field has been
renamed “Overbudget” and
customized with a formula
and graphical indicators.
Under Custom attributes , click Formula .
The Formula dialog box appears.
When writing a formula, use these buttons to insert
Project fields or functions into your formula.
This formula evaluates each task’s cost variance. If the task’s cost is 10 percent or less
above baseline, the formula assigns the number 10 to the task. If the cost is between
10 percent and 20 percent above baseline, it is assigned a value of 20. If the cost is
more than 20 percent above baseline, it receives a 30. These values of 10, 20, or 30
appear in the Number3 field customized to be Overbudget .
Click Cancel to close the Formula dialog box.