I have 3 fields, Building, Employee, and Sales. I have about 3,000 records in
total.

I can run a simple pivot table to show by building which counts the
employees and sums the sales. This is great but I'd also like to show a
calculated field and and show much sales per employee. When I try to add a
calculated field to do this it gives me a divide by zero. I think it is
because the employees are text but I'm not sure.

Thanks in advance for any suggestions or ideas.
-Mike