Help with summing records from multiple portals
I have multiple portals that are used to sort records for individual sports events. Each portal is used to 'rank' the players and is working as expected. The problem I can't quite get my head around is adding these records together to get a 'total rank' for each participant. I don't want the 'place' (1,2,3,4) I want the total points. Below is and example;
|Participant ID||Event 1||Event 2||Event 3||Total|
Each event is actualy a calculation of many records (amller events) so that is why I'm using portals to sort them. So how would I get the final 'Total' column? I cannot figure out a way to get the 'Rank' out of each portal.