Which "two red numbers" are being added? I can't spot any pattern as to what values are being added to produce the black colored values.
Is each row here a single record or a sub summary part based sub total?
Never mind on the "which two". I see the pattern now, but what kind of field is the highlighted field? How does "Then the numbers in the highlighted boxes are a result of a sort and conditional formatting." affect the value shown in that field?
The highlighted field is the result of a sort that pairs the lowest red number of each player, with the highest red number of each player. It is a team number that is assigned as a result of the sort. The team listed first is team 1, and then each player is assigned A, B, etc. The A or the B is determined by the value of the red number.
It goes all the way through the list of records and then delivers "teams" where the total of the red numbers is as close together as possible. This is trying to create "equitable teams" based on each player's "value" which is set by the red numbers.
The black numbers are the totals of each team's red numbers.
The highlighted field is the result of a sort that pairs the lowest red number of each player, with the highest red number of each player.
Am I correct then, that there are more players for each team than the two shown, the "highest" and "lowest" red number means that you are finding the player with the highest number and the player with the lowest number in that team?
Set up this self join relationship:
Players::TeamID = Players|SameTeam::TeamID
then Min ( Players|SameTeam::redNumberField ) + Max ( Players|SameTeam::RedNumberField )
will return the sum of the largest and smallest values for a given team.
Assuming that you have this data model:
You can define:
Min ( Players::redNumberField ) + Max ( Players::RedNumberField )
as a calculation field in Teams.
In this particular model, there are only 2 players per team. There could be other instances where there are 3, 4, 5 and 6 player teams. So, the summary total would need to be the total of all the "players" on each team, not just the lowest number and the highest number.
then Sum ( Players::RedNumberField ) will return that total.