AnsweredAssumed Answered

Turning a text "grade" into a calculated "score"

Question asked by tristan_jackson on Jan 6, 2018
Latest reply on Jan 8, 2018 by tristan_jackson

Hi community,


So I'm using the grading of "Good, Bad, Poor, Excellent" to evaluate a list of skills.  I then need that "grade" to give me a calculated score in another field. 


Very Poor = "30"

Poor = "40"

Fair = "50"

Good = "70"

Very Good = "80"

Excellent = "90"


What calculation should I be using?   IF or CASE and What can this look like? 


Overall I have about 20 skills to "grade" and each "score" will then need to be calculated into a "Overall Score"