Hi all,
I have a problem which I am unable to figure out. I have an input which shows different scenarios (E.g Scenario A, Scenario B) and the respective probability of success (See example input below)
Scenario A_Success | Scenario A_Fail | Scenario B_Success | Scenario B_Fail | Scenario C_Success | Scenario C_Fail |
0.99 | 0.01 | 0.94 | 0.06 | 0.12 | 0.88 |
I have to create an additional review column for each scenario such that: (See example output below)
Scenario A_Success | Scenario A_Fail | Scenario A_Review | Scenario B_Success | Scenario B_Fail | Scenario B_Review | Scenario C_Success | Scenario C_Fail | Scenario C_Review |
0.99 | 0.01 | good | 0.94 | 0.06 | good | 0.12 | 0.88 | bad |
How do I go about doing this? I have approximately 50 scenarios! Is there a better way to do it instead of creating 1 formula per scenario?
Thank you for the help!
Solved! Go to Solution.
Hi @Eug_teng ,
You can achieve that by using a multi-field formula tool with an If statement, checking if the value for either the success or fail fields is greater than or equal or below 0.9
So you don't have to go through all 50 fields and selecting manually on which fields you want to apply the formula, you can use a dynamic select tool before the multi-field formula tool, to select only the fields that contain Success or Fail in their names, and then apply the multi-field formula by selecting all available fields.
Hope that helps, let me know if you have any questions on the workflow.
Regards,
Angelos
Thank you both!