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

    Calculation Help

    Kevin Sullivan

      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.