I am looking for some help on this formula, Im not sure how to do it or even if my topic subject is correct.
Below I am creating a Leaderboard.
I am attempting to populate each teams score in the [leaderboard.score] column.
I have 2 tables relating to each team with their team name,owner and score. I am trying to filter the result to find the table that matches the team name and grab the score and populate the leaderboard.score column with the teams score.