I have a table with player points per game. Games are split by rows while points sit in a column.
In another table I want to work out the average points per game for that player.
From reading online I think ‘Rollup’ is what I should be trying. I get stuck as I seem to have to specify a record in the linked table in order to return any result - however obviously this means what I’m returning the average of one cell (which is not what I want).
The table design is as follows
Game | Points
A | 10
B | 20
Player career table
Average points per game
15 (this is calculated from the previous table)
Bonus point for telling me how to also calcluate ‘Most points scored in one game’ in the ‘Player career table’.