Using filter tool using multiple conditions

Question

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 NoStudent NameGradesRemarks100Humba Dela Cruz90Pass101Afritada Reyes74Fail102Bicol Express Jr.87Pass200Omelette delos Reyes95Pass209Biplop Sandoval85Pass208Laing Bernal82Pass305Sinigang Santos90Pass306Cornbip Lacson98Pass380Fried Egg Aguinaldo74Fail400Tocino Fernando III65Fail

Can you help me with this one pls?

AlexEntz · Answer

Hello,

here are the requested Filters in Order.

Workflow is attached as well.

filter.yxmd

Matt_D · Answer

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