Exception Focused Review - Review a Component Pass/Fail Specification Based on a Given Range - Tip287
OBJECTIVE or GOAL
Determine if and how a component passed or failed its specification based on a given range. We do not want to know if a component simply passed or failed; rather, we want to know if it failed on the low side of the range or if it passed on the high side of the range. We can use the CConst fields on the Component tab of the Processing Method to specify the values of an acceptable range.
ENVIRONMENT
- Empower
- Empower Tip of the Week #287
PROCEDURE
STEP 1
Create a Peak field (data type Enumerated.) An Enumerated data type allows you to string together multiple Boolean expressions (Figure 1).

STEP 2
In this case we have seven Boolean expressions, only one of which will return a "YES". The Boolean expressions are as follows (Figure 2):
- If the peak is missing, return a "Zero".
- If the amount is less than CConst7, return "Fail" (Low).
- If the amount is less than CConst6, return "Just Pass" (Low).
- If the amount is less than or equal to CConst5 and greater than or equal to CConst6, return "Pass".
- If the amount is greater than CConst4, return "Fail" (High).
- If the amount is greater than CConst5, return "Just Pass" (High).
- If CConst7 equals 0, report "Not Calculated".

STEP 3
The Translation Definition table shows the output of the custom field depending on which Boolean expression returns a "Yes" (Figure 3).

STEP 4
Populate the CConst3 through CConst7 with the appropriate values based on your assay (Figure 4).

STEP 5
One sample shows that amount of acetone in the sample "Just Pass" on the high side in the Peaks table in Review (Figure 5).

STEP 6
Create a View Filter on the Peaks tab in the Project window to display the results for this custom field (Figure 6).

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