I'm creating a report, with, for simplicity sake, has three 'tables'.

Companies----------Interactions (Left Outer Join)
          \
           \
            -------Employees (Inner Join)


I've successfully created a report that looks like this:

                 Phone Calls   Emails Meetings    Total
Microsoft              3          2        1          6
Google                 1          1        1          3

However, when I add a 'column' to the Detail section that also counts how many employees there are, all of my totals go completely out the door. Baffled as to why. My report looks like:

     
                 Phone Calls   Emails Meetings    Total
Microsoft             72        132       21       225
Google               41          31        11       83

I want a report that looks like this:

               Phone Calls   Emails Meetings    Total        Total Employees
Microsoft              3          2        1          6               15
Google                 1          1        1          3               114



Edited by khaines - 09 Jan 2012 at 8:46am

Many thanks. Can you tell me how to resolve?

You're dead on - I grouped on Company and I inserted a formula that basically said: (If [Field] = "Phone Call" then 1) and then summed the Phone Calls (Emails, Meetings, etc)

While there is a primary key for each row, I didn't paint the entire picture in my example. There is (for the employees) a field that is TRUE/FALSE that is basically something like "Full-time Employee". I'm trying to write a formula that says (If [Field] = TRUE then 1) and them sums it.

So, it will really look like this
                        Full-time        Part-time    Total
Google                      2               1          3
Microsoft                   4               -          4

Last question (for a while. RT? What is that?

note that a lot of people also refer to variable formulas that do counts as "Running Totals". It is a different way to do the same sort of thing, are usually formula fields written to use shared variables. When reading other posts keep it in mind that you may need to tease out which 'Running Total' is being referred to.