2 Replies Latest reply on May 28, 2010 10:19 AM by otto_m

    COUNT IF with certain values

    otto_m

      Title

      COUNT IF with certain values

      Post

      Hi, I'm turning to you with a basic problem:

       

      So far, I have used Numbers to evaluate placement test results. It has worked quite well, but is becoming painfully slow with 1500+ student records and a number of charts in the same document.

       

      As FM 11 features charts, I'm thinking of setting up a database to speed up the process. However, I have not been able to find an equivalent to an essential Numbers function:

       

      =COUNTIF(Table :: Column,">="0.9)

       

      Could somebody help me find an equivalent functon in FileMaker? 

      Thank you in advance,

       

      Otto

       

       

        • 1. Re: COUNT IF with certain values
          philmodjunk

          You have several possibilities in filemaker depending on your values and the structure of your tables.

           

          One method is to use two fields for this.

           

          Field1: Column > 0.9     (this field will return 1 for every record where column is greater than or equal to 0.9)

          Field 2; Summary, Total of  Field 1 (this will give you the total number of records where the expression in field 1 is true)

           

          There are also ways to set up a summary report with sub summary parts (or a chart with the same sub totals) that would use a Count of Summary field and sorting to group your records by the value to be sub-totaled.

          • 2. Re: COUNT IF with certain values
            otto_m

            Thank you Phil!

             

            The first method works great, and much much faster than Numbers:-)