Entering Threshold Value Conditions 

Use

Dependent on the numerical values of a certain report column (reference column) it is possible to use a threshold value condition to highlight in color/print report rows.

Your report has three columns: Actual costs, plan costs, and variance between actual and plan costs. You want to highlight in red all rows with variances greater than or equal to 10,000. To do so, you enter a threshold value. The threshold value in this example is 10,000 and the reference column is 3 (variance between actual and plan costs).

You can define a maximum of two threshold value conditions for each report.

You can define a threshold value condition whilst creating, changing, or displaying a report, or define it from the output report.

Procedure

To define the threshold value condition from either the Create Report/Change Report/Display Report initial screens, choose the Sections pushbutton and select the required report column. Choose the Threshold values pushbutton. The system displays the Maintain Threshold Value Condition for < section number > dialog box. Go to step 3.

  1. In report output, select the required report, then highlight the section for which you wish to define the threshold value condition.
  2. Select Edit ® Threshold value... The system displays the Maintain Threshold Value Condition for < section number > dialog box.
  3. Make the following entries:

If you want to enter one thousand, you should use the format 1000 and not 1,000 or 1.000.

Columns with column width zero (defined in the layout parameters) that are not displayed are, however, also counted. You can thus work with a reference column that is not output.

  1. You can enter additional threshold value information in the Extras group box:

To highlight all row values exceeding a specific threshold (be it positive or negative) in an actual/plan/variance report, you flag the Ignore +/- sign indicator.

  1. To specify a second threshold value condition, proceed in accordance with steps 2 and 3.

Example

A report contains the following columns:

You want to highlight in red all rows where the variance is greater than or equal to 10,000. Enter the following threshold value condition:

Choose Highlight selected rows (red).

In the same report, you want to highlight in red all rows where the variance is greater than or equal to 10,000. To do this, you enter the same conditions but select Print selected rows only. The system does not display any of the other report rows.