Logical operators in set analysis

[#1]

Hi all,

Can anyone explain me how the logical operators takes place in set analysis for below expression :

Count({$<DS={"Fail","Pass"}, LR={"Fail","Pass"}>} Distinct Lenskey)

i.e; which of the condition are correct for above set analysis

1.) Select Count (Distinct Lenskey) From table where DS ='Fail' or DS='Pass' or LR='Fail' or LR='Pass'

2.) Select Count (Distinct Lenskey) From table where DS ='Fail' and DS='Pass' and LR='Fail' and LR='Pass'

3.) Select Count (Distinct Lenskey) From table where (DS ='Fail' or DS='Pass') and (LR='Fail' or LR='Pass')

Thanks in advance

[Anonymous · Accepted solution]

Venkat

It is your:

     3.) Select Count (Distinct Lenskey) From table where (DS ='Fail' or DS='Pass') and (LR='Fail' or LR='Pass')

As in this bit means either Fail OR Pass

     {"Fail","Pass"}

and the comma in the middle seperate things as an AND

     {$<DS={"Fail","Pass"}, LR={"Fail","Pass"}>} Distinct

Best Regards,     Bill

[jchoucq]

i will say Option 3

Regards.

Johann

[#4]

Thanks to all your suggestion.

Regards,

Venkat