I am trying to create a weighted score based on the attached.
Scores 1 and 3 should make 20% each of the overall, with Score 2 making up 60% of the overall. On the attached I just have a simple average sitting in the overall column but that clearly works on the proviso that scores 1-3 are all weighted equally.
I have tried altering my overall expression to include the multiplying of scores 1 and 3 by 0.2 and score 2 by 0.6 but it wasn't working.
Can anyone help me work out what I need to do to get the desired result?