Computed Field for bulk options with many probablity logical conditions

Question

I am working on deriving the default output for a choice field in our project, based on other two choice lists and on conditions that depend on fields with 4 and 5 choices. I have implemented the probable conditions as shown below, but currently I am only able to get the result for a single condition. Could you please help me obtain the output values for all the possible conditions or suggest the correct expression to handle these cases.

These three lists are used together to assess the overall risk.

Impact Rating (choiceList[2]):

ID 1: Severe

ID 2: High

ID 3: Medium

ID 4: Negligible

Feasibility Rating (choiceList[3]):

ID 1: Very Low

ID 2: Low

ID 3: Medium

ID 4: High

Risk Level (choiceList[4]):

ID 1: L1

ID 2: L2

ID 3: L3

ID 4: L4

ID 5: L5

This is the expression i am trying in computed as box in risk level choice list

List(choiceList[4]_$option[
    (choiceList[2][0].id == 1 && choiceList[3][0].id == 4) ? 5 :
    ((choiceList[2][0].id == 1 && choiceList[3][0].id == 3) ||
     (choiceList[2][0].id == 2 && choiceList[3][0].id == 4)) ? 4 :
    ((choiceList[2][0].id == 1 && choiceList[3][0].id == 2) ||
     (choiceList[2][0].id == 2 && choiceList[3][0].id == 3) ||
     (choiceList[2][0].id == 3 && choiceList[3][0].id == 4)) ? 3 :
    ((choiceList[2][0].id == 1 && choiceList[3][0].id == 1) ||
     (choiceList[2][0].id == 2 && choiceList[3][0].id == 2) ||
     (choiceList[2][0].id == 3 && (choiceList[3][0].id == 2 || choiceList[3][0].id == 3))) ? 2 :1])

Istvan_Molnar · Accepted Answer

Hello,

please try the following computed formula:

List(
 choiceList[4]_$option[
 List(
 List(0,0,0,0,0),
 List(0,2,3,4,5),
 List(0,1,2,3,4),
 List(0,1,2,2,3),
 List(0,1,1,1,1))
 [choiceList[2][0].id]
 [choiceList[3][0].id]
 ]
)

Regards,
Istvan

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded