Help: Applying formula over multiple fields

[Eug_teng]

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)

• If probability of success or probability of failure >= 0.9, review = good
• If probability of success or probability of failure < 0.9, review = bad

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!

[Qiu]

@Eug_teng 

Hope this is what you need.

[AngelosPachis · Accepted 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

[Eug_teng]

Thank you both!