Show TOC

 Entering Threshold Value Conditions Locate this document in the navigation structure

Prerequisites

You can enter a threshold value condition in the executed report in order to emphasize or print report rows with color highlights, depending on numerical values or specific report columns (reference columns).

Procedure

  1. Choose   Edit   Threshold value   and enter the condition in the dialog box.  

  2. ( )

    Your report has columns for actual costs , plan costs , and variance between actual and plan costs. You want to emphasize all rows with variances greater than or equal to 10,000. To do so, you enter a threshold value. In this example, the condition is >=, the threshold value is 10000, and the reference column is 3. You also need to set the Threshold Value Condition Active indicator.

  3. Choose Additional options to determine whether to highlight the selected rows, or whether to print only those report rows that fulfill the threshold value condition. In addition, you determine whether to ignore the plus/minus sign during value selection for those values fulfilling the condition.

  4. Choose Further condition to enter a second threshold value condition.

Note Note

If you use a standard layout in report definition with the Changes allowed during execution indicator activated under Page/Control , you can save changed threshold values for future report callups.

End of the note.

For more information, see the SAP Library under   FI-Financial Accounting   FI-Special Purpose Ledger   Report Writer   Report Writer Reports   Defining The Report Header