Calculating team size using iterative macro

[Dheeru28]

Hi All,

I have this workflow with an iterative macro. I had downloaded the macro from some other post on the community. What I want to get as output is the team size for all the employees who are managers. I have attached a sample workflow with dummy data.

In the real data (the one I have), the results are correct for most employees, but incorrect for managers with very large teams. I'm unable to find what is the problem.

Can someone please help out?

[Dheeru28]

Yes, on this sample data, it's correct. But on my data, it's not. For many people, the team size is lesser than it should be.

I guess I must be missing something.

[Christina_H · Accepted solution]

As an alternative, try filtering after the macro to see if that makes a difference.  It gives the same results on the sample data.

[Dheeru28]

This worked. Was right in front of me and I was looking everywhere else.

Thank you so much, really appreciate the help!!