Minus min calculation problem
Hoping this is something dumb that i am just missing...
I have a script that (I think) used to work before Filemaker 9.
In a scoring system I am simply dropping 1 score if a person has more than 2 scores. The calculation works fine UNLESS all 3 scores are the same. Apparently Filemaker can't drop a min score if they are all the same, if none of the 3 scores are less than the others. Maybe this NEVER worked and I just never noticed it, but I don't think so. I can't believe that Filemaker wouldn't be able to drop a score if they are all the same.
Basically, a particular rider got 1st place, 1010 points at all 3 events. I need his Total Points to be best 2 out of 3 scores, so 2020 total points. Right now he has 3030 points, while everyone else is working correctly.
Sum(USASA_Results.vBoarder_ID::SL_NationalPoints) - Min(USASA_Results.vBoarder_ID::SL_NationalPoints)
Works fine is 1 of the 3 scores is less than the others but if all 3 scores are the same it doesn't drop anything.