Count

[#1]

I Have two columns

A          B                         C

1          passed          passed

1        passed          ready

i want count of passed and ready for service id's (i.e column a)

i want logic if column B is passed and Column C is passed then consider as passed

but  if column B is passed and Column C is ready then consider as ready

Please help

[#2]

this should do the trick:

count({<B={'passed'}, C= {'passed'}>}A)

regards,

MT