Conditions in expressions combo

neeenz — Fri, 02 Oct 2015 15:55:21 GMT

Hi guys,

Currently working on a project where there are 2 dropdowns involved, the combination of the 2 will result to a 3rd Combo

Scenario

Combo 1

4=Critical

3=High

2=Medium

1=Low

Combo 2

3= High

2=Medium

1=Low

Combo 3 Results (i'm doing a substring(Combo1,1,1) and substring(Combo2,1,1) to extract just the first digit)

3=High if Combo 1 * Combo 2 > 6

2=Medium if Combo 1 * Combo 2 < 6 BUT > 2

1= Low if Combo 1 * Combo 2 < 3

Combo 3 has a formula of:

(concat(number(substring(combo1,1,1)) * number(substring(combo2,1,1)), "=Low")| concat(number(substring(combo1,1,1)) * number(substring(combo2,1,1)), "=Medium")) [number(substring(Combo1,1,1)) * number(substring(Combo2,1,1)) < 3]

I've been getting this error "Actual Value...", clearly I'm doing this the wrong way. Anyone knows how to deal with multiple conditions in an expression? :D Any help is much appreciated

**I've tried Rules as well, but it seems it's miscalculating the values at some point (might have been doing it wrong) :(

InfoPath 2010

Conditions in expressions combo