Hi,
I am wondering if there is a way to assign a numerical value to a text answer. Here is an example of what I am trying to do:
A survey is designed for inspectors to fill out. As they answer questions like,
"What is the distance to the nearest fire extinguisher?"
1: 10 ft.
2: 50 ft.
3: 100 ft.
I would like to assign a numerical value to those answers so 1 point for 10 ft., 5 points for 50 ft., and 10 points for 100 ft. At the end, I would like to be able to tally up the results of my survey with a total score for every answer to a question and be able to assign a risk value that the inspector can both see and submit in the form.
Is this possible?
THANKS!
Hi Jacob,
your system may be assuming the '2's are text, and not integers. Try puting int(2)+int(2)+int(2). This will force the system to treat them as numbers and not as a text string.