2 Replies Latest reply on May 17, 2010 1:56 PM by Matrixxdg

    Summary of Data

    Matrixxdg

      Title

      Summary of Data

      Post

      Hi All,

      I am new to FM Pro and currently using 9.

       

      I have what I hope is a simple question that has a simple answer.  I have a table that has fiel called Payment_types. It is a drop down list that has Check and Cash in the values.

       

      I am trying to create a summary page that counts how many records has the word cash in that field and how many that has the word check in the field.

       

      Thanks...MG

        • 1. Re: Summary of Data
          philmodjunk

          You can use a "count of" summary field in a summary report for this.

           

          Set your summary field to count  a field that is never empty.

           

          In your summary report, change the body part to a subsummary when "sorted by" Payment_Types.

           

          Place your new counting summary field in this layout part.

          Select view as list, sort your records by Payment_Types and enter preview mode. (Grouped summary reports aren't visible in versions 9 and older until you preview and/or print the report.)

          • 2. Re: Summary of Data
            Matrixxdg

            Thanks Phil.... Worked perfect.

             

            Mike G