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).
5 Replies
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?
