Reporting on weighting result for each question
Content
Hi all
Hoping that I can get some help from the network!
I am trying to produce a formula that lists the results for each of the questions answered by a candidate as determined by the weighting. I am able to find an overall score [Application Score], but can't split it further.
For example -
Answer A = 1
Answer B = 5
Answer C = 10
Answer D = 15
I am able to do this manually by returning a number when a candidate selects a particular answer
eg
=ToNumber(If([Candidate Answer ID (Choice)]="15277";"1";If([Candidate Answer ID (Choice)]="15276";"5";If([Candidate Answer ID (Choice)]="15275";"10";If([Candidate Answer ID (Choice)]="15274";"15")))))