Is it possible to create a formula that sums values in other rows based on a filter with the current row’s other column value?
For example, let’s say I have 3 columns:
- Topic (Primary Field)
- Owner: Person object (other table) or email address
- Score: Integer field
I want to calculate the sum of all Score fields where the Owner is the same.
From a table perspective, I was thinking about adding another column with a function like the following:
SELECT SUM(Score) WHERE Owner = this.Owner
This will result in the same value for all rows where Owner is the same, but I’m okay with that.
What’s the best way to accomplish something like this?