Forum Discussion
Formula for weighted scoring to exclude 'n/a' rows/topics
The answer is chosen from a drop-down list. The weighted score needs to adjust if a row is chosen as 'not applicable' (n/a).
How is the weighted score calculated?
- It is just a number out of 100 - so 4 sections would make up 100%. This section was allocated 30%. I was playing around with percentage per row/item as well - but still can't figure it out. Let me know if I should forward the file
I don't understand what you want to calculate. Could you provide a specific example of a few answers with the desired outcome?
Hi Hans, thanks for trying to help.
I actually managed to figure it out 🙂
Just needed a nudge as to what I'm trying to achieve - thanks for this!
