New Contributor

# 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

# Re: Formula for weighted scoring to exclude 'n/a' rows/topics

How is the weighted score calculated?

# Re: Formula for weighted scoring to exclude 'n/a' rows/topics

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

# Re: Formula for weighted scoring to exclude 'n/a' rows/topics

I don't understand what you want to calculate. Could you provide a specific example of a few answers with the desired outcome?

# Re: Formula for weighted scoring to exclude 'n/a' rows/topics

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!

# Re: Formula for weighted scoring to exclude 'n/a' rows/topics

Good to hear that you solved it yourself!