You can use the Filter tab of the Forecast Preferences dialog to discard values inside or outside a range for the current forecast or globally for all forecasts in a model. The values are not permanently deleted, only discarded for the purposes of the current analysis.
Select from the following settings:
Set A Filter On The Forecast Values — Activates the filter settings for the forecast.
Include Values In The Range — Discards values from the forecast if they fall above or below the two values in the range text boxes. Endpoints are included, not excluded.
Exclude Values In The Range — Discards values from the forecast if they fall between the two values in the range text boxes. The range is inclusive; Crystal Ball discards values inside the range as well as values equal to the range endpoints.
When filtering values for this forecast, remove values for the same trial from other forecasts too — For each trial that a value is not included or is excluded, removes the value for that trial from all other forecasts in the model, and assumptions too. For example, if the filter for the current forecast is set to include values from 4 through 10 and the value for the third trial is 12, the value for the third trial will be filtered from the current forecast and all other forecasts and assumptions in the model, regardless of the values in the other forecasts. If this setting is selected and you run a Forecasts report, “globally filtered” is displayed for the forecast in the Summary data following the filter description.
Note: | This setting can be selected in the Define Forecast dialog for several forecasts with different filter settings. In that case, filtering for each selected forecast will be applied across all forecasts. |
Click OK to apply settings on the current tab to the active forecast. Or, you can click Apply To to apply settings on the active tab to the active worksheet, the active workbook, or all workbooks. At any time, you can click Defaults to restore the original default settings on the active tab in the dialog.