Select to view content in your preferred language

Assign a numerical value to a text answer

3943
10
08-02-2018 01:30 PM
RobertMarros
Occasional Contributor II

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?

Survey123 for ArcGIS‌ 

THANKS! 

0 Kudos
10 Replies
NicCrossett
New Contributor

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.

0 Kudos