Hi, I’m analysing the compliance of bartenders who have to serve a beer in 5 steps.

Each Step can be Compliant (True) or Not-compliant (False).

I would like to compute a ‘Compliance score’ for each bartender.

The formula to compute the score would be this:

Compliance score = X

If(Step1=true) And If (2 other Steps = true) Then X = True

In other words, the bartender MUST be compliant on Step 1 and Must be compliant on at least 2 other steps to be fully compliant.

How can I write this with the Query Builder?

If it’s not possible, is it possible to count the number of compliant Steps for each bartender and say If equal or larger than 3, then the bartender is compliant?

Also, where can I find a guide on how to write Custom Expressions?

Thank you very much for your help.