Windchill Risk and Reliability Desktop Help > Overview > Functions > Calculating > Calculation File > One-Level Deep Rule
One-Level Deep Rule
For all table types but the FMEA Worksheet, you can use the first four aggregate functions described in Field Functions only with tables that are one level below the result table. An example follows:
• It is valid to calculate IncidentValue1 = SumField(MaintLogValue1) because the FRACAS Maintenance Logs table is one level below the FRACAS Incidents table.
• It is not valid to calculate SystemValue1 = SumField(MaintLogValue1) because the FRACAS Maintenance Logs table is two levels below the FRACAS Incidents table.
The following table shows which tables support the use of these four aggregate functions. Information about how the FMEA Worksheet table is an exception to the one-level deep rule appears in FMEA Worksheet Table Exception. FMEA Tree subtables are available only in the Enterprise Edition.
Result Table
Table Type of Field Used in Function
System Tree Items
FRACAS Incidents
Configurations
FRACAS Incidents
FRACAS Operating Time
Problems
Problems Subtable 1-15
FMEA Worksheet (if Action data level is in use)
FRACAS Incidents
FTA Diagrams
RBD Diagrams
RBD Blocks
System Tree Items
FRACAS Incidents
FRACAS Maintenance Log
FRACAS Incidents Subtable 1-15
FMEA Table
FMEA Table Subtable 1-15
FMEA Worksheet (any higher-level field)
FMEA Worksheet (any lower-level field)