1 Reply Latest reply on Sep 15, 2014 5:59 AM by philmodjunk

    Calculation for a result between two teams

    tomo17

      Title

      Calculation for a result between two teams

      Post

      I have a sports league database where I am able to import a series of stats and game scores.  Each game has a unique number (GameID) so for each game their will be two records - one for each team. Each record will include a score field.  Is there an easy way that I can write a calculation so that a result field will give either Win, Loss or Draw depending on the score for that team for that game.