Calculation Types by Data Type
The Test Results Consolidated page processes test results from multiple test orders and consolidates them using various calculation methods based on the data type of each test property. This consolidated information forms the basis for Customer Certificate generation, ensuring accurate and reliable quality documentation.
The calculation types available depend on the Result Type of the test property and provide different consolidation methods to meet various quality control requirements. A new test property uses Latest Value as the default Calculation Type. If you change the Result Type to Boolean, a calculation type that is not available for this data type, such as Min, cannot be selected and causes an error.
Calculation Types Overview
The following sections describe the calculation types available for each data type and their specific usage in the consolidation process.
Integer/Decimal Data Types
Numeric data types support the most comprehensive set of calculation options for consolidation:
| Calculation Type | Formula | Usage Description |
|---|---|---|
| Min | Smallest measurement value | Stores the lowest value from all test results. Used for properties where the minimum acceptable threshold is critical (e.g., strength testing, purity levels). |
| Max | Largest measurement value | Stores the highest value from all test results. Used for properties where maximum limits are important (e.g., contamination levels, dimensional tolerances). |
| Average | Sum of all values ÷ Count | Calculates the arithmetic mean of all determined values. Most commonly used for quality metrics where the central tendency represents the property (e.g., weight, concentration, temperature). |
| Standard Deviation | Statistical dispersion from mean | Calculates the standard deviation of measurements as the square root of variance. Used for specification compliance verification and statistical process control. |
| First Value | Chronologically first measurement | Uses the first recorded measurement based on sorting setup. Useful for initial quality assessments or baseline measurements. |
| Latest Value | Chronologically last measurement | Uses the most recent recorded measurement based on sorting setup. Important for final quality confirmation or trending analysis. |
| Mode (Most Frequent Value) | Most commonly occurring value | Identifies the value that appears most often in measurements. Useful for discrete numeric properties with expected standard values. |
| Sum | Total of all measurements | Stores the cumulative total of all measurements. Used for additive properties or when total quantity is relevant (e.g., total impurities, cumulative wear). |
| K.O. Criterion | Fail if any measurement out of tolerance | If at least one measurement falls outside the defined tolerances, the entire test property is considered failed. Critical for strict quality compliance where all measurements must be within specification. |
Boolean Data Types
Boolean properties (Yes/No, Pass/Fail, OK/Not OK) support these consolidation methods:
| Calculation Type | Logic | Usage Description |
|---|---|---|
| Average | Majority rule (>50%) | Returns "true" if at least half of the values are true, otherwise "false". Democratic approach for general quality assessments. |
| First Value | Chronologically first result | Uses the first determined boolean value based on sorting setup. Maintains original assessment priority. |
| Latest Value | Chronologically last result | Uses the last determined boolean value based on sorting setup. Emphasizes most recent quality status. |
| Mode (Most Frequent Value) | Majority with 50%+1 logic | Uses majority rule where the determined value reflects the value of more than 50% of recorded measurements. |
| K.O. Criterion | Fail if any measurement fails | If at least one measurement is negative (e.g., "not OK"), the entire test property is considered failed. Critical for go/no-go quality decisions. |
Option Data Types
Option fields with predefined value lists support these calculation approaches:
| Calculation Type | Logic | Usage Description |
|---|---|---|
| Average | Majority rule consolidation | Uses majority rule for consolidation. Contains the Expected Value if at least half of the determined values match the expected value, otherwise contains the Out-of-Spec Value. |
| First Value | Chronologically first option | Uses the first selected option value based on sorting setup. Preserves initial classification or grade assignment. |
| Latest Value | Chronologically last option | Uses the most recent selected option value based on sorting setup. Reflects final quality determination. |
| Mode (Most Frequent Value) | Complex majority logic | - Two options: Uses majority rule (50%+1) similar to boolean logic. - Multiple options: Only assigns determined value if majority matches expected value, otherwise remains empty to indicate inconclusive results. |
| K.O. Criterion | Fail if any indicates failure | If any measurement indicates failure status, the entire property fails. Used for critical classification systems. |
Text Data Types
Text properties have focused consolidation options for maintaining traceability:
| Calculation Type | Logic | Usage Description |
|---|---|---|
| First Value | Chronologically first text | Preserves the first recorded text measurement based on sorting setup. It is important for maintaining original operator notes, batch identifiers, or equipment references. |
| Latest Value | Chronologically last text | Uses the most recently recorded text value based on sorting setup. Captures final observations, updated batch information, or most current equipment status. |
Usage Patterns in Customer Certificate Context
The following sections describe typical applications of the calculation types, grouped by quality management purpose: quality control, safety and compliance testing, traceability and documentation, and statistical quality management.
Quality Control Applications
- Min/Max/Average: Commonly used for dimensional measurements, chemical properties, and physical characteristics where statistical analysis provides meaningful quality insights.
- Standard Deviation: Enables specification compliance verification for critical quality parameters requiring statistical process control.
Safety and Compliance Testing
- K.O. Criterion: Ensures that any failing measurement triggers overall failure for critical safety properties, maintaining strict quality standards.
- Boolean Average: Provides majority-rule approach for pass/fail determinations based on statistical assessment requirements.
Traceability and Documentation
- First Value/Latest Value: Maintain comprehensive audit trails for batch information, operator identifications, equipment references, and process conditions.
- Text consolidation: Preserves critical textual information such as visual observations, operator notes, and environmental conditions.
Statistical Quality Management
- Mode calculations: Identify standard or expected values in discrete measurement systems, helping detect process variations or equipment drift.
- Sum calculations: Support cumulative quality assessments for additive properties or total quantity measurements.
Integration with Customer Certificates
The consolidated results populate Customer Certificates with reliable, statistically sound measurements that meet regulatory and quality requirements. The Test Order Output Value field shows the value that was determined on the test order that was last processed for the consolidated result. It is transferred to Customer Certificate lines for all calculation types, which provides traceability from the individual measurement to the certificate. For calculation types such as Average or Standard Deviation, this value is not the consolidated result itself.
With consolidation, you can maintain rigorous quality standards while adapting the calculation type of each test property to your specific testing requirements and regulatory compliance needs.
Standard Deviation
The Standard Deviation calculation type for Integer and Decimal data types measures how widely the recorded values are spread around their mean. It is calculated as the square root of the variance, which is the sum of the squared differences from the mean divided by the number of values. If only one value exists, the standard deviation is 0.
Each time a test order is finished, consolidated results are calculated for every calculation type that is valid for the data type of the test property. For numeric test properties, the standard deviation is therefore calculated per item and lot or serial number, together with the other calculation types.
A Customer Certificate line uses a consolidated result only if both of the following conditions are met:
- The test plan that is used for the certificate contains the same Test Property Set Code and Test Property Code as the consolidated result. The test plan of the test order and the test plan of the certificate must therefore contain the same test properties.
- The Calculation Type of the test plan property is Standard Deviation.
The result is then handled like any other numeric result:
- If the Type of the test plan property is Actual Value, the calculated standard deviation is shown as the output value. It is rounded to the Succeeding Decimal Places of the result type, or to a whole number if none are defined.
- If the Type is Reported Value, the calculated standard deviation is verified against the expected value or the upper and lower limits of the test plan property. If it is within the specification, the reported value is shown. Otherwise, the out-of-spec text or the calculated value is shown, depending on the Out-Of-Spec. Type.
Sorting Setup Details
The "sorting setup" referenced in First Value and Latest Value calculations refers to a specific sorting algorithm that determines chronological order for test results consolidation.
Sorting Mechanism
The First Value and Latest Value calculation types use a multi-level sorting approach based on:
- Test Order No. (primary sort key)
- Test Order Property Set Line No. (secondary sort key)
- Test Order Property Line No. (tertiary sort key)
The finished test orders are sorted by Test Order No., regardless of when each test order was finished.
Implementation Logic
- First Value: Determined by the finished test order with the smallest Test Order No.
- Latest Value: Determined by the finished test order with the largest Test Order No.
The order in which test orders are finished does not affect the result. For example, if TO00046 is finished after TO00056, the value from TO00046 is still the First Value in the consolidated result.
Critical Requirements
Only finished test orders are included in the consolidation process. Test orders with recorded values that remain unfinished do not contribute to the First Value/Latest Value calculations, ensuring data integrity and preventing incomplete results from affecting quality determinations.
Example
Consider ten test orders created for LOT0021 with values recorded but only specific orders finished:
| Test Order No. | Values Recorded | Finished Status | Result Usage |
|---|---|---|---|
| TO00046 | ✓ | - | Not Used |
| TO00047 | ✓ | - | Not Used |
| TO00048 | ✓ | Finished | First Value |
| TO00049 | ✓ | - | Not Used |
| TO00050 | ✓ | - | Not Used |
| TO00051 | ✓ | - | Not Used |
| TO00052 | ✓ | Finished | Latest Value |
| TO00053 | ✓ | - | Not Used |
| TO00054 | ✓ | - | Not Used |
| TO00055 | ✓ | - | Not Used |
When additional test orders are subsequently finished (e.g., TO00047 and TO00054), the First and Latest designations update based on Test Order No. sequence, not finishing order:
- TO00047 becomes the new First Value (smaller Test Order No. than TO00048)
- TO00054 becomes the new Latest Value (larger Test Order No. than TO00052)
This ensures that the First and Latest designations depend on the Test Order No. rather than on completion timing, providing consistent and predictable consolidation behavior.
Data Type Applicability
This sorting setup applies uniformly across all data types supporting First Value/Latest Value calculations:
- Integer/Decimal: Numerical measurements
- Boolean: Pass/fail determinations
- Option: Selected classification values
- Text: Textual observations and notes
The consistent sorting approach ensures reliable traceability and chronological accuracy regardless of the property data type being consolidated.
Feedback
Submit feedback for this page .