9 Replies Latest reply: Jan 18, 2017 4:07 AM by Mich Oikonom RSS

    Sum goals a team has suffered

    Mich Oikonom

      Hi,

       

      this is a sample of  my scheme:

       

       

      MatchIDTeamPlaceGoals
      1CesenaHome2
      2BariHome4
      3LivornoHome4
      1BresciaAway0
      2SpeziaAway3
      3PescaraAway0

      You can see all the data in the attached file.

       

      My problem is that i can easilly sum per team all goals that it have achieve, but i can't find a way to sum all the goals a team has suffered. For example, Bari, with MatchID=2, put 4 goals and suffered 3. Do you have any suggestion on that?

       

      Thank you in advance