Amount diffence from first record

[mikajake]

I have a database that has a results page. Like so:

game 1 game 2 game3 total behind pos

100 200 300 600 ---- 1

99 156 210 455 145 2

I can get the totals to work but How do i get the amount of points behind the leader. I have a maxtotal field set as a container. then when i do the report i set that field to the value of the first records total. Then for the second and subsequent records, I take the container field and subtract the 2nd records total. and the position is a ranking field that will show ties if they happen, eg 1,2,3,4,4,6,7,7,9 etc

Edited April 21, 2009 by Guest

[Ocean West]

I am confused why are you using a "container" field to store this data?

Can you elaborate a bit more?

[mikajake]

I would like to know how to get a report based on the three tournaments to look like the attached file. As you can see, all other players are behind the leader by x amount of points. So I guess I am creating a leader board with rankings.

tourn.pdf