1 2 Previous Next 24 Replies Latest reply on Oct 25, 2016 1:12 AM by sam0723

    Conditional Value List Counting

    sam0723

      Hello, everyone, i am new to filemaker. i am working on the value list counting of the student

       

      Here is part of my database.

       

      Class A

       

      Student ID   Name     Country          Catagory

      1                   John         USA               Local

      2                   Mary         Canada          non-local

      3                   Tracy         China               Local

       

      so in this record, i have created a calculation field to count the number of country in class using

       

      ValueCount(ValueListItems ( "" ; "Country List" ))

       

      The value is 3.

       

      Now, my client would like to count the local students only. So that the value of number of country in class should be 2.

      How could i selectively count local student. Do i need to create another field to mark the record and count this field?

        1 2 Previous Next