Hi,
There's a status for persons in the database.
I want to remove persons in a list that have the status L or W in combination with status B or if L or W occurs more than two times per person.
I want to do that in a straight table and not in the script.
Been experimenting with a few things but haven't cracked the complete code.
Any help is welcome.
Below are some of the expressions I've been trying to get the correct result with.
=COUNT({(<STATUS = {L}> + <STATUS = {B}>) * (<STATUS = {L}> + <STATUS = {W}>)} PERSON)
=sum(if(Aggr(Count(DISTINCT(STATUS)),STATUS)>=2,1))
if(aggr( Concat(len(STATUS)>2),1,2),STATUS)