Copy link to clipboard
Copied
I created a transcript template. How can I make it calculate the Grade points Earned.
If I input 6 in the credit hours attempted column and an "A" in the grade column, I would like for it to automatically calculate 24 in the grade points earned column. How would I go about doing this?
The grades would be:
A = 4
B = 3
C = 2
D = 1
F = 0
Thank you!
Copy link to clipboard
Copied
Use a drop-down menu for the grades and enter the grade letter as the "Item" and the value as its "Export Value", like this:
Then you would be able to simply multiply the grade field by the hours field to get the score.
Copy link to clipboard
Copied
Thank You!
Find more inspiration, events, and resources on the new Adobe Community
Explore Now