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

    Conditional Value List Counting


      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