Handri

Text Variable to Number Variable

Discussion created by Handri on Nov 18, 2015
Latest reply on Nov 18, 2015 by 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

Outcomes