Text Variable to Number Variable

Discussion created by Handri on Nov 18, 2015
Latest reply on Nov 18, 2015 by Handri



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 ?