Text answer to question needs to be converted to number

general discussion
1

We have a picklist of answers to a question and I need to assign each answer a score and then total the score. How do I assign the number to the answer?

Example:

Less than six months should have a score of 5.

Thank you!

2

What have you tried? You have not provided enough information for a comprehensive answer (e.g., valid answers).

A variable with a formula as follows might be a good start.

=If ([Answer] = “Less than 6 Months”) Then
5
ElseIf ([Answer] = “6 Month to a Year”) Then
10
Else
15

Noel

3

Hi Noel,

Thank you for replying! Can you tell I’m a newbie? :sunglasses:

I have a variable that worked until I referenced it in another variable to Sum numbers. Then I received a DataType error.

I have 4 fields that I will need to do this to (2 are yes/no so they should be easier). Then I need to sum the numbers from all 5 fields.

Should the variable that assigns the numbers be a Dimension or Measure?

Again, thank you for your help!
Mary

4

Newbie? We have all been newbies at one time or another. You have come to the right place!

Can you provide some sample data that fits your situation as I describe in this post?

Also, along with your test data mock up in Excel your expected result.

Noel

5

I figured it out! ElseIf statement works. Thank you!

1 Like