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

1

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?

coda%20calc
coda calc.JPG945×195 12 KB

2

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