Using Exceptions 

Creating an exception

You define an exception from the drilldown list. Once you have defined the exception, it also appears in the detail list and can be changed there.

The cursor position determines for which element the exception is to be defined. The area of validity for the exception is determined as in the following example. The example report has been defined to yield a two-line column header. Consequently, the columns are grouped together into column groups.

If you choose to define an exception for the range Column, the following scenarios are possible:

If you define an exception for a Cell, it applies for a specific characteristic value. In the above example, it is clear from the header of the list which country and customer the exception is valid for, regardless of the cursor position. If the cursor is positioned on A, this means that it also applies to the product "Tomatoes".

Displaying, changing and deleting exceptions

You can display the exceptions which exist for a report under Extras ® Display exceptions. You obtain a list of all the exceptions in the report. When you double-click on an exception, the system displays the parameters for that exception in a subsequent dialog box. If you have created other exceptions for this report, you can then display these using the functions Previous exception and Next exception. You can change and delete individual exceptions in a similar fashion under the menu option Change exception. If you want to delete all the exception in a report, choose Delete exceptions.

Use of exceptions in report lists

It is possible to define more than one exception for a single cell. It may then occur that one exception is "normal", the next one "green" and the third one "red". In this case the system follows the priority rule: red, green, normal. This means that if at least one exception has the condition "red", the system displays that cell in red. If "red" does not occur and one of the exceptions has the condition "green", the cells appears in green. The normal color only appears when all of the exceptions for that cell have the condition "normal".

See also:

Creating Exceptions

Editing Exceptions