I am trialling this software for potential use. I have entered 13 games worth of data and am having as problem with 1 data field. If I look at BOXSCORE report it shows all of my players 'singles' per game. However when I look at Overall Games report, it reports '0' singles for all players. Any new game I enter from now, shows the singles. IS there a way of 'fixing' the previous 13 games so the singles appear in the overall games report
For overall reports, be sure SUM() is used for the formula in the 'Result' field (This is availabe when editing a field). So, from your example, the result field would look like:
sum(s.singles)