CapIDFinal:= SWITCH(TRUE(), AND(CONDITION_1_1, CONDITION_1_2), “Value if condition 1 is true”, AND(CONDITION_2_1, CONDITION_2_2), “Value if condition 2 is true”, “Value if none of above conditions is true )
CapIDFinal:= SWITCH(TRUE(), AND(CONDITION_1_1, CONDITION_1_2), “Value if condition 1 is true”, AND(CONDITION_2_1, CONDITION_2_2), “Value if condition 2 is true”, “Value if none of above conditions is true )