Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2006

    Unanswered: Rating 1-5 With 1 Being The Best. Can You Help?

    Rating 1-5 with 1 being the best

    I have a table that has a total number of apps per rep. I would like to score my reps on a 1-5 scale.

    The formula I thought would work was 0to5: [3MRank]/([Past_3_Month#]-1)*5

    But this data went from 0.00000.24464 to 123.35544

    Can someone help me find the correct way to get the results Im looking for.

    Thank you.

    If it helps database attached
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts