I apologize if this has been discussed previously, but I couldn’t find anything similar in my search.
I have a base which represents, essentially, a weekly golf tournament. There’s a table of golf rounds, with each record associated with a week and a player. There’s a formula field that calculates that round’s deviation from the average score from all the players that week.
What I need to do is have a calculated field in each of those recirds which represents the player’s handicap for that round, which is the average of all of those deviations for all of the previous weeks, but not the current or later weeks.
Is there some way to accomplish this?