Skip to main content
Solved

Formula to exclude calculation

Hi All,

I have two fields participants name and participants category. I need to count total of the participant but to exclude one of the participant categories, for example teacher category.

The table is as shown below

Participants name | Participants category

David                         | Teacher
Nadia                         | Student
Sam                            | Scholar


Rather than count total of 3 participants, because its excluded teacher category, the result will show total 2 participants.

Can you please explain to me available formula for this case?

Many Thanks



------------------------------
Syaeful Bahri
------------------------------

Best answer by MarkShnierYou

You have not stated if you have any relationships. 

But if you have a relationship where One Scheduled Course Class has Many Participants, you can make a Summary on that Relationship to count the number of Participants. but out a filter on that Summary field 
where Category os not Teacher.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
View original
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You have not stated if you have any relationships. 

But if you have a relationship where One Scheduled Course Class has Many Participants, you can make a Summary on that Relationship to count the number of Participants. but out a filter on that Summary field 
where Category os not Teacher.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement