Use this field to enter a descriptive name for the condition item. This name is displayed in the condition list on the Conditions dialog.

Generate name automatically?

Use this check box if you want Discoverer to create a default name for you. The default name is based on the condition syntax.

What description would you like to give your condition?

Use this field to enter a brief description for the new condition. This description is displayed in the description box on the Conditions dialog and helps workbook users choose which condition they want to use.

Formula

This area is where you build the condition. The condition can contain one or more condition statements.

Item

Use this drop down list to filter the worksheet by selecting an item to match against. For example, to filter information about people whose salary is more than $30,000, you might choose an item called 'Salary' here.

To insert a calculation to use in the condition formula, choose Create Calculation... to display the "New Calculation dialog".

Condition

This drop down list displays a list of logical operators that you can use to match against the Item selected. For example, to filter information about people who earn more than $30,000, you might choose the 'greater than' operator (>) here.

For more information on logical operators available, see Notes below.

Values

Use this field to enter (or select from the drop down list) one or more values you want to use to match against the selected Item. For example, if you want filter information about people who earn more than $30,000, enter 30,000 here.

You can also choose from the following options:

To match the selected item against a new calculation, choose Create Calculation to display the "New Calculation dialog".

To match the selected item against an existing worksheet item, choose Select Item to display the "Select Item dialog".

To match the selected item against a new worksheet parameter, choose New Parameter to display the "New Parameter dialog".

To specify a date using a graphical calendar, click the down arrow to the right of the field and choose Select From Calendar to display the "Calendar dialog".

If the Item has an LOV that is too long to display, choose Select Multiple Values to search for and select values using the "Select Values dialog".

Note: You can enter up to 254 values in this field. To enter more than 254 values in the condition, click Advanced and use the OR option to add a new condition statement line for the extra values.

Hint: If you are entering a percentage value, enter the decimal value of the percentage. For example, enter '.5' for 50% (for more information, see Notes below).

Case sensitive

Use this check box to make the condition case sensitive when matching against text data. For example, if turned on, the value 'New York' would not find details containing 'NEW YORK'. If turned off, the value 'New York' would find details containing 'NEW YORK' and 'new york'.

Advanced

Use this button to expand the dialog box enabling you to apply multiple condition statements to an item. The expanded dialog displays New Item, And, Or, Delete and Undo buttons. A Group column is also added to the Formula box (see Group below).

Expanded Advanced options

New Item

Use this button to add a new condition statement line to the condition. By default, new condition statement lines are grouped with the logical AND operator. In other words, the data must satisfy both condition statements to be filtered in the worksheet (see Group below).

And

Use this button to add a new condition statement line to the condition and group it with the previous condition statement line with a logical AND operator. Using 'AND' narrows a search to display only items that match all criteria. For example, with two condition statements, data must match condition statement one and condition statement two.

Or

Use this button to add a new condition statement line to the condition and group it with the previous condition statement line with a logical OR operator. Using 'OR' widens a search to display items that match any of the criteria. For example, with two condition statements, data must match either condition statement one or condition statement two. (In SQL terms, this is an inclusive OR clause.)

Delete

Use this button to remove the currently selected condition statement line from the condition.

Undo

Use this button to retrieve the deleted condition details if you delete a condition statement line from the condition and then change your mind.

Group

AND

Use this button to change the Group operator to a logical 'AND'. You must have the current Group item selected. Using 'AND' narrows a search to display only items that match all criteria in the group.

OR

Use this button to change the Group operator to a logical 'OR'. You must have the current Group item selected. Using 'OR' widens a search to display items that match any of the criteria in the group.

NOT AND

Use this button to change the Group operator to a logical 'NOT AND' operator.

NOT OR

Use this button to change the Group operator to a logical 'NOT OR' operator.

Notes

The following table describes logical operators available when matching data against items.

Operator

Meaning

How it is used

=

equals

Year = 2001

Display only data for the year 2001.

<>

Not equals

Year <> 2001

Display data where the year is not 2001

>

Greater than

Clicks > 10

Display data where the number of clicks on a Web site is more than 10

<

Less than

Salary < 50,000

Display data for people who earn less than 50,000

LIKE

Similar to

Employee_name LIKE CH%

Display data for employees whose name begins with CH.

IN

Equal to any member of

WHERE job IN ('CLERK','ANALYST');

If you are creating a condition that filters a Percent Rank or Percentage Contribution calculation, you must enter the percentage value as a decimal value. For example, to find values in the top 50%, you enter '.5' in the Values field, not '50'.

This is because the underlying worksheet values are decimals, not integers. Discoverer applies the whole number formatting to the decimal values.

To create a condition that filters out null values, enter NULL, 'NULL', or "NULL" in the Values field. Discoverer converts the value to IS NULL.

Scripting on this page enhances content navigation, but does not change the content in any way.