1 Reply Latest reply on May 23, 2012 12:50 PM by gkaiseril

    Need help assigning 2 values to each choice in a drop down

    CardinalV

      I'm trying to create a tool for tracking students' grades and credits.  There is a drop down menu with A - F as choices, and I assigned export values 4,3,2,1,0.  I can then get weighted average by using the simple average calculation in a text field box somewhere else on the page. 

       

      What I want to do is also assign grades A-D a value of .5 so that we can keep track of how many credits a student has.  Then all I will need is to find the sum in another box. 

       

      How do I pull this off?  Thank you for your help.