I'm trying to improve upon my gradebook db. Right now, I can either enter grades as % or as decimals in order to get an average. A coworker asked if I could assign a value to letter grades (IE A=4.0, A-=3.63, B+=3.38, etc) to make gradebook entry easier for teachers who would have to look up the number equivalents.

I'm familiar with boolean yes/no, but is there a way to get FileMaker to equate a decimal value based on the letter grade I enter in a field? I tried creating a value list that displayed the letter grade and 'also showed' the number equivalent so they wouldn't have to mentally keep track but the value list only displayed the first entry for each letter (IE A, B+, C+, D+ and F).

Any suggestions will be greatly appreciated. I'm very new to FM. Thanks.

Hi,

You could have the letter grades in one field grade_let and the value in other grade_val.

The value field should be a calculation field: grade_val=If(Grade_let="A";4.0;If(Grade_let="A-";"3.63";If(Grade_let="B+";3.38;"")))

Then arrange the both fields together.

ZZ

Thanks for jogging my memory. Since I needed to include several more conditions (12 grades in all), I switched to Case and ended up with what I believe will be a solution to my problem. Thanks, again!