Anybody know how to do a summary search by employee count (i.e. sum of invoice totals / employee count). Here I’m trying for total time entry hours by employee count but the math doesn’t work correctly.

What summary are you using for that formula row?

SUM, I just guess on that one. Should be in the screenshot.

Ha! Would help if i expanded them!

I’ve tried all the summary types, they all result in 1.13 as a result.

Hmmm, my guess is that the COUNT in your formula is not the same as the COUNT summary type. Let me try something real quick.

That’s it! Yeah before it must have been counting every line instead of every unique employee.

Nice!