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

    Converting words to numbers

    Cellanurse86

      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:

      Exceeds

      Achieves

      Below

      Unsatisfactory

       

      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!


      Cheers!