2 Replies Latest reply on Nov 18, 2015 6:59 AM by Handri

    Text Variable to Number Variable




      I have a question, I have one field say it GRADE(Text) which have 3 value (A,B,C) as a drop down menu.


      How can I make a a summary calculation (Number) using those A(3) or B(2) or C(1) as a value ?


      For example


      A Team

      X give A (3)

      Y give B (2)
      Z give C (1)


      SUM (Grade for A team)


      Do I have to set the field as a calculation ? or run this calculation with script ? What function should I need for this ?