Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

My multiplication keeps giving an error

Topic Labels: Formulas
Solved
Jump to Solution
2195 4
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
)