Skip to Content
Former Member
Jan 28, 2008 at 05:29 PM

Show Team Statistics and Percentages


Post Author: dkotenoglou

CA Forum: Formula

I have a Team Report that shows the following:Any Request that was closed on the same day the request was submitted.Grouped by the Individual who Closed itWith a running subtotal next to each nameWith a Grant TotalSo for exampleSally Smith 23Bob Jones 16Larry Marks 10Sam Sparks 31Jeff Kunk 17Others 10Total 107Now, Sally and Bob are one team and the other employees are on another team.I now want to show statistics by Team. So in effect what I am looking for isTeam A 39 36%Team B 58 54%Others 10 9%Total 107This

is a Notes Based system so I cannot go to the "server" side and make

changes. I tired using Summary and Formula Fileds, but I got lost. I

would imagine I would just add to the existing report, but I am not

sure how.I also dont feel like making several subreports any direction?