Version: Windchill 12.0
Use Case: Matrix with "double" result + calculation Matrix A = 1 Matrix B = 2 Matrix C = C1 with A manage by the horizontal axis + B manage by the vertical axis Calculation Matrix C : $Case( [FmeaTable.FmeUserText15] == "Yes" && [FmeaTable.FmeUserText19] == "Yes" , 1 , [FmeaTable.FmeUserText15] == "Yes" && [FmeaTable.FmeUserText20] == "Yes" , 1 , [FmeaTable.FmeUserText15] == "Yes" && [FmeaTable.FmeUserText21] == "Yes" , 1 , [FmeaTable.FmeUserText15] == "Yes" && [FmeaTable.FmeUserText23] == "Yes" , 1 , [FmeaTable.FmeUserText13] == "Yes" && [FmeaTable.FmeUserText19] == "Yes" , 1 , [FmeaTable.FmeUserText13] == "Yes" && [FmeaTable.FmeUserText20] == "Yes" , 1 , [FmeaTable.FmeUserText13] == "Yes" && [FmeaTable.FmeUserText21] == "Yes" , 1 , [FmeaTable.ItemDescription] == "Yes" && [FmeaTable.FmeUserText18] == "Yes" , 1 , [FmeaTable.ItemDescription] == "Yes" && [FmeaTable.FmeUserText21] == "Yes" , 1 , [FmeaTable.ItemDescription] == "Yes" && [FmeaTable.FmeUserText23] == "Yes" , 1 , [FmeaTable.FmeUserText15] == "Yes" && [FmeaTable.FmeUserText22] == "Yes" , 2 , [FmeaTable.FmeUserText15] == "Yes" && [FmeaTable.FmeUserText17] == "Yes" , 2 , [FmeaTable.FmeUserText15] == "Yes" && [FmeaTable.FmeUserText18] == "Yes" , 2 , [FmeaTable.FmeUserText13] == "Yes" && [FmeaTable.FmeUserText23] == "Yes" , 2 , [FmeaTable.FmeUserText14] == "Yes" && [FmeaTable.FmeUserText16] == "Yes" , 3 , [FmeaTable.FmeUserText14] == "Yes" && [FmeaTable.FmeUserText19] == "Yes" , 3 , [FmeaTable.FmeUserText14] == "Yes" && [FmeaTable.FmeUserText22] == "Yes" , 3 , [FmeaTable.FmeUserText14] == "Yes" && [FmeaTable.FmeUserText17] == "Yes" , 3 , [FmeaTable.FmeUserText14] == "Yes" && [FmeaTable.FmeUserText20] == "Yes" , 3 , [FmeaTable.FmeUserText14] == "Yes" && [FmeaTable.FmeUserText18] == "Yes" , 3 , [FmeaTable.FmeUserText14] == "Yes" && [FmeaTable.FmeUserText21] == "Yes" , 3 , [FmeaTable.FmeUserText14] == "Yes" && [FmeaTable.FmeUserText23] == "Yes" , 3 , [FmeaTable.FmeUserText15] == "Yes" && [FmeaTable.FmeUserText16] == "Yes" , 3 , [FmeaTable.FmeUserText13] == "Yes" && [FmeaTable.FmeUserText22] == "Yes" , 3 , [FmeaTable.FmeUserText13] == "Yes" && [FmeaTable.FmeUserText18] == "Yes" , 3 , [FmeaTable.FmeUserText13] == "Yes" && [FmeaTable.FmeUserText16] == "Yes" , 4 , [FmeaTable.FmeUserText13] == "Yes" && [FmeaTable.FmeUserText17] == "Yes" , 4 , [FmeaTable.ItemDescription] == "Yes" && [FmeaTable.FmeUserText16] == "Yes" , 4 , [FmeaTable.ItemDescription] == "Yes" && [FmeaTable.FmeUserText19] == "Yes" , 4 , [FmeaTable.ItemDescription] == "Yes" && [FmeaTable.FmeUserText22] == "Yes" , 4 , [FmeaTable.ItemDescription] == "Yes" && [FmeaTable.FmeUserText17] == "Yes" , 4 , [FmeaTable.ItemDescription] == "Yes" && [FmeaTable.FmeUserText20] == "Yes" , 4 , 1 == 1 , "" )
Description:
Matrix with "double" result + calculation
Application : Windchill Risk and reliability
Product : Entreprise
Version : 12.0.4.0 (same on 13.0.2.1)
Currently - Working as designed - Generation of a Matrix and Manage the calculation on a Matrix :
to manage inverted colors
to manage calculation by row/column (instead of by cell)
to manage by column/row spanning
to manage exclusion (instead of inclusion)
Currently Result - if nothing is select to calculation :
All Matrix/Table is green and not transparent (Screen shot "Matrix C.png" in comment)
Currently Result - Calculation by row/column :
Not easy to update the matrix,
Calculs done on row/column and manage exclusion on the result => it is not ideal (Screen shot "Matrix C Calcul.png" in comment)
IDEA NEED -
Manage the calculation and the result on a matrix should be performed cell-by-cell :
=> Correct Calculation by row/column
=> Correct inverted colors
=> Correct exclusion result
This is already feasible, but it requires a great deal of manual effort to implement a calculation inverse to the existing one, and the configuration is complex.
It would be preferable to handle the calculation directly within the application's functionality.
