Sum not Concatenate in "select one" rows

Question

Currently I have two rows in a survey that are set as “select
one” (see below-Failure Potential and Damage Potential). Is there a way to keep
them set as “select one” so that the selections have text associated with them and
have them sum,  NOT concatenate via
a calculation (see Hazard Rating below)?

Failure potential:

1-very low

2-low

3-moderate

4-high

Damage potential:

1-very low

2-low

3-moderate

4-high

Sum like this:

Hazard Rating: 5

NOT concatenate this

Hazard Rating: 23

GarretDubois · Answer

Thanks Hannah, that did the trick. I appreciate your help. garret Garret Dubois Biological Science Technician Forest Service Alaska Region, Forest Health Protection p: 907-743-9469 f: 907-743-9479 garretddubois@fs.fed.us 161 East 1st Ave. Door 8 Anchorage, AK 99501 www.fs.fed.us [Forest Service Twitter][USDA Facebook] Caring for the land and serving people image003.png image002.png image004.png image001.png

HannahFerrier · Answer

Have your tried casting your values as integers?

int(${value_1}) + int(${value_2}) should give you the sum of the integer values instead of concatenating the strings.

- Hannah