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 ?
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 ?