Averaging the score from multiple rows... only in each group

When I run a calculation, it seems to want to apply it to every row. Is it possible to have the calculations only in one group (by margin)?

Each group has 2-3 rows and a slider outputting a number. I want to take those numbers and have one calculation in the group as a sum of those numbers. Is that possible?

Hi @THNQ - is this what you are looking for.
Here I used this formula on the Average Column -
thisTable.Filter(Name=thisRow.Name).Values.Average()

1 Like