Creating a Calculation Condition

A calculation condition denotes the status of an object at the time a calculation was performed. Calculation states use these conditions when determining the status of an object. Examples of conditions include excellent, good, fair, and bad. Each condition can also be assigned colors for a visual cue in tables and charts.
This section describes how to create a calculation condition.

To Create a Calculation Condition

1.
2.
Select the Customization Center view.
3.
Select the Calculations tab and then the Settings tab.
4.
Select the Conditions tab. This tab displays a list of calculation conditions for the enterprise.
5.
Click New. The Calculation Condition dialog appears.
6.
7.
8.
Select the Relative condition from the list.
9.
In the Formatting options area, select a font, text color, and background color to be used in tables.
10.
In the Chart Banding options area, select a color for the band to be used in charts.
11.
Click OK to save the changes. The calculation condition appears in the list.