5 Replies Latest reply on Nov 10, 2014 12:46 PM by Cellanurse86

    Converting words to numbers


      Hi all!


      I've seen multiple questions/answers about converting numeric values to words in Java, but I have the reverse issue. 


      I've created a performance management appraisal (dropdown box) with the following ratings:






      However, in order to execute some calculations, I need to assign numeric values to each

      Exceeds (4); Achieves; (3) Below; (2); Unsatisfactory (1).


      I would REALLY appreciate it if someone could help me with the code for this.  My intent is create a separate field called "r_value" to display the number (I'll make this invisible later) and use for other calculations.


      Also, I'm assuming this should be written as a Validation script, correct? 


      Thanks SO much!