Help with filtered sum

1

I have a button that I would like to populate a field (integer) with the sum of a field from the same table but only for the last 60 days and only for the same team member as the current row.

I’ve tried many ways but I’m just having trouble getting my head around this.

This is my most recent attempt but it isn’t returning the correct value.

ModifyRows(thisRow,thisRow.[60 Work Life Average],sum(thisRow.[Work-Life Balance].Filter([Team Members].Name = thisRow.[Team Member].Name AND Date>= (Today() - 60))))

How can I get this value?

2

Any way you’d be willing to share a dummy doc??

3

It’s in the 1:1 Meetings in the Copy Data button

4

I modified the button, ran the actions, and got these results.

Before I explain whats going on and how to approach these problems in the future, can you confirm I got your intended result?

image
image1888×1062 155 KB

5

Thank you!

Looking at your code it looks so simple! I don’t see how I missed it!

I added the date range parameter but everything is working well.

Thanks, again!

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.