2 Replies Latest reply on Jan 10, 2013 11:40 AM by Kevin Sullivan

# Calculation Help

I have 4 fields Month, Lateral Count , Vertical Count, Employee count.  Employee Count has a "1" for every record while Lateral and Vertical only have a "1" if appropriate.  When I roll the month up to Quarter the employee count gives me the sum for all 3 months (75k) but I need the average of the sum for the 3 months (25k).  If i change Employee Count to Average it give me "1"  The other fields I just want to sum for the quarter.

• ###### 1. Re: Calculation Help

Kevin,

Does your data only have those four fields or is there something like Employee ID where you could do a Count Distinct?  That would work no matter how you rolled it up (though it is different than average).

If you really want an average, I think it would be possible.  Do you happen to have some sample data (even dummy data) you could share?

Joshua

• ###### 2. Re: Calculation Help

This actually seemed to have worked!

Sum([Employee Count])/COUNTD([Month])