Hello. I hope someone can assist me. I am trying to create a "rating score" based on 5 data points, with a percentage/weight given to each point. I want to have a rating of 1-10 (with 10 being the best). In the attached sample, I have applied 10% to one field, 15% to another, then 5%, then 70%. The TAT field represents number of days (the lower the better) and this is the most important piece of criteria. I'm not sure if a separate table would be needed for that.
Sorry if it seems confusing as I am trying to transfer what I'm thinking in my head to this message. Thank you in advance for any suggestions.
Bookmarks