Calculated columns with letters

%3CLINGO-SUB%20id%3D%22lingo-sub-2967554%22%20slang%3D%22en-US%22%3ECalculated%20columns%20with%20letters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2967554%22%20slang%3D%22en-US%22%3EHi%20all%20I'm%20looking%20for%20some%20help.%3CBR%20%2F%3EI%20have%20a%20list%20with%20exam%20questions.%3CBR%20%2F%3EEach%20question%20has%204%20choices.%20They%20are%20a%2Cb%2Cc%2Cd%3CBR%20%2F%3EThe%20exam%20is%20run%20through%20power%20apps.%3CBR%20%2F%3EHowever%20I%20need%20to%20calculate%20a%20final%20exam%20score.%3CBR%20%2F%3EThe%20correct%20answer%20is%20given%20a%20score%20of%204%20the%20rest%20are%200.%3CBR%20%2F%3EI%20have%20no%20idea%20how%20to%20weight%20the%20alphabetical%20values%20with%20a%20numeric%20one.%3CBR%20%2F%3E%3CBR%20%2F%3ETIA%3CBR%20%2F%3EPaul%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2967554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Hi all I'm looking for some help.
I have a list with exam questions.
Each question has 4 choices. They are a,b,c,d
The exam is run through power apps.
However I need to calculate a final exam score.
The correct answer is given a score of 4 the rest are 0.
I have no idea how to weight the alphabetical values with a numeric one.

TIA
Paul
0 Replies