Exception Focused Review - Flagging Results That Fail Specification Based on a Given Range - Tip288
OBJECTIVE or GOAL
Create a Custom Field that flags a result if any component fails its specification based on a given range.
ENVIRONMENT
- Empower
- Empower Tip of the Week #288
PROCEDURE
STEP 1
Create a Peak Custom Field (data type Boolean) that is based on the outcome of the custom field created in Tip #287. If a component passes the Custom Field, it will return a "NO". If the component is missing, or if it fails or just passes, it will return a "YES" (Figure 1).

STEP 2
Create a Result Custom Field (data type Boolean) that is based on the outcome of the custom field created in Step 1. If all components pass, this custom field will return a "NO". If one or more components fail or just pass, it will return a "YES", which indicates the result needs further investigation (Figure 2).

STEP 3
The Results window within Review will display the results of the Peak Custom Fields in the upper table and the Result Custom Fields in the middle table. Note that one peak is flagged as "Just Passed (High)"; therefore, the entire result is flagged (Figure 3).

STEP 4
Create a View Filter for the Results tab of the project window to include the outcome of the custom field created in Step 2. (Right-click on the Result Set and select "View As, Results".) Note that three out of four results in the Result Set have been flagged and require further investigation (Figure 4).

ADDITIONAL INFORMATION
This can be done with either the Pro or QuickStart interface.
