Help

Re: My multiplication keeps giving an error

Solved
Jump to Solution
792 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Chioma_Kalu
4 - Data Explorer
4 - Data Explorer

Hi,

I am trying to figure out why I keep getting this error message:
Screenshot 2021-12-22 at 14.18.32

The Impact Value is the average of the Confidentiality, Integrity and Availability column. (Confidentiality+Integrity+Availability)/3

The Risk Value should be multiplying the Impact Value with the Likelihood Value. But I am getting an error message with this basic formula {Impact Value}*{Likelihood Value}

Please help.

1 Solution

Accepted Solutions
Rupert_Hoffsch1
10 - Mercury
10 - Mercury

Hi and welcome to the Airtable community :slightly_smiling_face:

The output of a single select is not a number but a string. So you have to convert that string to a number first which you do with Value({Likelihood Value}).

Cheers,
Rupert

See Solution in Thread

4 Replies 4
Rupert_Hoffsch1
10 - Mercury
10 - Mercury

Hi and welcome to the Airtable community :slightly_smiling_face:

The output of a single select is not a number but a string. So you have to convert that string to a number first which you do with Value({Likelihood Value}).

Cheers,
Rupert

Amazing! This worked. Thank you so much!

That helped me, too. I’m trying to average scores from a survey, but my survey has 19 questions. Worse yet, my fields are more like “My position is a good fit for someone with my knowledge, skills, and personality.”

Do I need to apply the VALUE function to each field (question)? In the example above, would I need to apply VALUE({Confidentiality}) and VALUE({Integrity}) and VALUE ({Availability}) and so forth or is there a better way? Is there a Value version of Single Select?

I found the number field type, which might do the trick. Is there a way to limit number responses to within an acceptable range?

There is not a way to limit a number field to a range in a form. Is your maximum number is 10 or less, you could use a rating field, which can have a maximum value of 10 or less.

If you want to keep your answer fields as single select values with text values, you can use a SWITCH formula to convert the text to a number.

SWITCH( {singe select field name},
    "High", 5,
    "Medium", 3,
    "Low", 1
)