Thank you so much for your input, that would definitely work to show a users rank out of all users but it wouldn’t constrain the results in a scale of 0.00 to 10.00 i might not have explained it properly the first time and im sorry if thats the case! but ill see if i can re phrase the example, So users have a total score made up of a number of factors (this iv got working fine) what im trying to do is display a score/rank on their profile base on their overall score against all other users where 10.00 is the highest and 0.00 is the lowest, meaning the user with the highest score has a rank/score of 10.00 and the user with the lowest score has a rank/score of 0.00 for example…
if there are three users their rank/scores would be
UserA - 10.00 (highest overall score)
UserB - 5.00
UserC - 0.00 lowest score
if the are eleven users:
If there are 21 users
User R 1.50
examples with overall scores
UserA overall score of 5 - rank 10.00
UserB overall score of 3 - rank 5.00
UserC overall score of 1 - rank 0.00
second example with all over scores
UserA overall score of 98 - rank 10.00
UserB overall score of 67- rank 5.00
UserC overall score of 49 - rank 0.00
Sorry if thats abit OTT but i hope you get the gist, so it doesnt matter which user currently holds the top and bottom spot, is just matters what the top and bottom overall scores are and where the current users sits between those two points.
so i guess it needs to take into account the total number of users, the highest overall score the lowest overall score and where the current users overall score sits between those two points relative to all other users overall scores?
i hope thats a better explanation?