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?

Outcomes