Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

Translate the entire conversation x

Computed Field for bulk options with many probablity logical conditions

PN_10920746
2-Explorer

Computed Field for bulk options with many probablity logical conditions

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])

 

 

ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

2 REPLIES 2

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

Hello,

 

I have tried the computed formula you provided and it worked.

 

Thank you for your reply.

Announcements


Top Tags