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

    Text Variable to Number Variable

    Handri

      Hi

       

      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 ?

       

       

       

      Regards,

       

       

      Handri