Entering Threshold Value Conditions

Use

You can specify a threshold value condition so that report rows are highlighted or hidden depending on the numerical values of a certain report column (reference column).

Note Note

You can only define threshold value conditions in the displayed report in expert mode .

End of the note.

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

Example Example

Suppose your report has three columns: actual costs, plan costs, and variances between actual and plan costs. You want to highlight in red all rows with variances of at least 10,000. To do so, you enter a threshold value. In this example, the threshold value 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.

End of the example.

Procedure

Note Note

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. Continue with step 3.

End of the note.

  1. In report output, select the required report and then highlight the section for which you wish to define the threshold value condition.

  2. Select Start of the navigation path Edit Next navigation step Threshold value.. End of the navigation path . The system displays the Maintain Threshold Value Condition for < section number >dialog box.

  3. Enter the following information:

  • Specify a condition for the threshold value. For example, if you want to display values for a certain report column greater than 10,000, you enter >= in the Condition field.

  • Enter the threshold value. You can enter the threshold value with or without decimal places. You can only use a period or comma for the decimal places. The threshold value itself must not contain a period or comma.

  • Enter the position number of the reference column. The columns are numbered from left to right, starting from the first report column.

Note Note

Columns with a column width of zero (defined in the layout parameters) which are therefore not displayed are nevertheless included in the numbering. This means that your reference column does not have to be displayed.

End of the note.

  • Use the Active indicator to specify whether the threshold value condition is active or not.

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

  • The Ignore +/- sign indicator tells the system whether it should ignore the +/- sign when determining which values fulfil the threshold value condition. Select this indicator if you want the report writer to ignore the +/- sign.

Example Example

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

End of the example.

  • You use the indicator Only detail rows to restrict the where-used area of the threshold value condition. If you select this indicator, the totals rows are not included in the threshold value condition. They are printed unchanged when the report is output.

  • If you just want to print the report rows conforming to the threshold value condition, choose the Print selected rows only indicator. The system hides all other report rows.

  • To highlight the rows fulfilling the threshold condition in red, choose the Highlight selected rows (red) indicator.

  • To highlight the rows fulfilling the threshold value condition in green, choose the Highlight selected rows (green) indicator.

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

Example

Suppose a report contains the following columns:

  • Actual costs (column 1)

  • Plan costs (column 2)

  • Actual/plan variance (column 3).

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

  • Condition >=

  • Threshold value condition 10000

  • Reference column 3

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. All other report rows are hidden.