2 Replies Latest reply on Mar 19, 2014 10:52 AM by beverly

    Count not working correctly

    mitchelllbuchanan

      I have a detailed report of all of the students seperated by class

       

      When I try to do a count it counts everyone instead of counting by class

       

      Is there something I could put under the detail fields in the report to make it start counting again from 0?

        • 1. Re: Count not working correctly
          DavidJondreau

          You don't say how you're "counting". There are various ways.

           

          You need a summary field that counts the primary key and you need to place that on a sub-summary part sorted by class. That's if you on a layout based on students.

           

          If you're on a layout based on classes, you need a calculation field that counts related students.

          • 2. Re: Count not working correctly
            beverly

            do you have the field in a subsummary part on the report layout? and are you sorting by the class?

             

            An aggregate, such as Count(), will mean different values based on where it's placed on a layout. The same field in a subsummary (with sort) will be just those records. Put that field in a grand summary or footer and you get the TOTAL of all records in the found set (regardless of sort).

             

             

            HTH,

            Beverly