Using filter tool using multiple conditions

[dunkindonut7777]

Hi I have a problem here that I want to filter it using the criteria below:

1. How many students failed?
2. How many students have 80 and above grade and less than 90?
3. How students have Student Numbers that ends with 0?
4. How many students with names started with letter B?
5. How many students Students Number thats ends with 0 and Passed?

Student No	Student Name	Grades	Remarks
100	Humba Dela Cruz	90	Pass
101	Afritada Reyes	74	Fail
102	Bicol Express Jr.	87	Pass
200	Omelette delos Reyes	95	Pass
209	Biplop Sandoval	85	Pass
208	Laing Bernal	82	Pass
305	Sinigang Santos	90	Pass
306	Cornbip Lacson	98	Pass
380	Fried Egg Aguinaldo	74	Fail
400	Tocino Fernando III	65	Fail

 Can you help me with this one pls?

[Matt_D]

Hi @dunkindonut7777 

Using the Custom filter in the Filter Tool this is the syntax I would use, you can take out the bits you need into separate Filter Tools (or even the Formula Tool if you looking to add another column to classify. Just be aware that a student can fall into more than one of these categories.) as required as you don't specify an output

[Remarks] = "Fail" //How many students failed?

OR ([Grades] >= 80 AND [Grades] < 90) //How many students have 80 and above grade and less than 90?

OR EndsWith(ToString([Grades]), "0") //How students have Student Numbers that ends with 0?

OR StartsWith([Student Name], "b") //How many students with names started with letter B?

OR (EndsWith(ToString([Student No]), "0") AND [Remarks] = "Pass") //How many students Students Number thats ends with 0 and Passed?

Matt

[AlexEntz]

Hello,

here are the requested Filters in Order.

Workflow is attached as well.