Hi. I have a database of tennis matches for which I've built a query that gives me columns for the player's name, the number of times a first serve was won and the number of first serves that were 'called in'. As the query originally pulled all the matches and thus duplicated each player's name I added column totals and grouped by player name by selecting sum for fields 2 and 3.
Now I want to work out the % of times a first serve that was called in was won by dividing column 2 by column 3. I duly added a new expression field doing just that but as this wasn't included in the grouping I got all the duplicate player names back again.
I'm now stuck as to how to get the true % as sum seems to run the calculation for each instance of the player name and then sum these figures - this unsurprisingly gives over 100% in some cases. What should I do? Thanks in advance.
Now I want to work out the % of times a first serve that was called in was won by dividing column 2 by column 3. I duly added a new expression field doing just that but as this wasn't included in the grouping I got all the duplicate player names back again.
I'm now stuck as to how to get the true % as sum seems to run the calculation for each instance of the player name and then sum these figures - this unsurprisingly gives over 100% in some cases. What should I do? Thanks in advance.