Using Boolean "Or" Calculations

For example, you want to search for companies that have P/E in a 20 to 25 range or PEG Ratio of 1. We will use DBCM items 72 - P/E using F(1) Estimate and item 551 - PEG Ratio (P/E F(1)/ EPS Growth). We will use the Direct Method for creating this calculation expression.

Here is how you can define these conditions:

From the Screen menu, select the Screen by Calculation Expression command or click the Screen by Calculation Expression button.

  1. The Calculation Expression window will appear.
  2. In the Calculation Expression data entry box, type the following formula:
    i72>20 And i72<25 Or i551=1
  3. Click OK.
  4. The Screen By dialog box will appear. Select TRUE from the menu options.
  5. The Screenin Criteria table will fill up showing the calculation. The Report Definition will also contain the calculation. You may want to delete it from the Report Definition, because every company will have 1 as the data value. Instead, you may want to include the items 72 and 551.

Back | Examples | Help Home Page