AnsweredAssumed Answered

Averaging Stats For a Basketball Tournament

Question asked by MikeProcopio on Jul 6, 2014
Latest reply on Jul 9, 2014 by philmodjunk

Title

Averaging Stats For a Basketball Tournament

Post

     In my solution I want to track points for different tournaments a player plays. I have a player table, an event participation table, and an event table.

      

     <Player::_pk_PlayerID>----------<_fk_PlayerID::Event Participation::_fk_EventID>----------<Event::PK_EventID>

      

     In the event participation I have scouting report for the game, but want to add stats like points and rebounds etc which isn't a problem. I would like to have a field to average the stats in each event for each individual player, but having an issue making it work for some reason.

     I tried a summary field in the Event participation table, but that wouldn't work for one reason or another.

     If I have 5 entries for a player in Event 1 I would like for it to give me the average for that specific event as well as the average for Event 2, 3, and likewise. 

      

     Thanks

Outcomes