Sorting and Filtering System Tree Items by Failure Rates
Many tables, including the System Tree Items table and Parts Table, support filtering. This means that you can use the filter bar, which is shown by default above the column headings in these tables, to quickly and easily sort and filter by fields in the table. For more information, see
Filter Bar for Filterable Tables.
Because sorting and filtering by Failure Rate, Predicted allows you to efficiently determine which assemblies and/or parts are the most or least reliable, such actions are extremely valuable. However, to effectively sort and filter by predicted failure rate values, you must understand the difference between how these calculated values are displayed in these tables versus how they are stored in the database.
• In the System Tree Items table and Parts Table, the values for Failure Rate, Predicted are shown with a precision of six decimal places.
• In the database, the values for this field are stored with a much higher precision level.
This means that if you use a value displayed in these tables to set an “is equal to” filter, a match is not found. Because of the precision difference between the displayed and stored values, an inability to find a match occurs even if you copy the data from Failure Rate, Predicted and paste it in the criteria selection control of the filter bar.
Consequently, when you filter the parts for an assembly by predicted failure rates, you should use the “is greater than” and “is less than” conditions rather then the “is equal to” and “is not equal to” conditions.