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.

5

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
.

6

Click
Cancel
to close the
Formula
dialog box.