AnsweredAssumed Answered

Conditional Value List Counting

Question asked by sam0723 on Oct 18, 2016
Latest reply on Oct 25, 2016 by 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?