2 Replies Latest reply on Feb 2, 2009 6:18 PM by comment_1

    Minus min calculation problem

    skdmarx

      Title

      Minus min calculation problem

      Post

      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. 

      Any ideas?