Hi,
I'm trying to determine whether a selection is in the bottom (say) 3 weights (in horse racing).
There are conditions for checking whether a selection is top or bottom weight, but I can't see how to determine anything in between. You can sort selections by silk_weight (I guess), but then how do you determine which selection sits where in the list if it's not at the top or bottom of the list? Is there a way of indexing into that (internal) list?
Put simply, I want to be able to discount a selection if it is in the bottom 3 weights.
If it is the bottom weight, that's easy. But second or third bottom?
Maybe an idea for a new selection condition?
We have 1st - 5th favourite and probable loser based on price. Maybe a similar thing for weights?
Top weight, 2nd top weight, 3rd top weight, bottom weight, 2nd bottom weight, 3rd bottom weight?
regards
Wez