Hi, I've been away from FM for quite some time and just returning to using it again, I'd forgotten just how much I love it, but the grey matter is a bit rusty. My questions is,
I'm designing a database which needs to calculate a score from a weight field.
It needs to sort the weight from highest to lowest and give a rank and then a score.
So the biggest weight will be 1st with 100 points. Second biggest will be 2nd with 99 points, etc. Those not entering a weight will all get the rank after the smallest weight. They will get 20 points less than the smallest weight.
Matching weights will get the same score and points, but the next weight will have to skip a place and a point.
Hope that makes sense.