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 I’m looking for.
Thank you.
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 I’m looking for.
Thank you.
