Hello, everyone, i am new to filemaker. i am working on the value list counting of the student
Here is part of my database.
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?