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.
You have to use unique values in a drop down, combo, or list box.