topic Re: multiple Or-And conditions in one expression in App Development

multiple Or-And conditions in one expression

Prachi_Pradip_Kulkarni — Tue, 16 Nov 2021 12:30:03 GMT

Hi,

I am trying to implement following if condition in set analysis:

IF condition: count(distinct if(R1='YES' or R2='YES' or R3 ='YES') and Flag=1),ID)

set analysis: count(distinct {<{R1='YES' + R2='YES' + R3 ='YES'},Flag=1>}ID)

also tried count(distinct {<R1='YES',Flag=1 + R2='YES',Flag=1 + R3 ='YES',Flag=1}ID)

But it's Not working...

What can I do to solve this with set analysis?

Thank you in advance.

Best regards

brunobertels — Tue, 16 Nov 2021 12:49:23 GMT

Try this

count(distinct {<R1={'YES'}> + <R2={'YES'}> + <R3 ={'YES'}>,Flag={1}>}ID)

stevejoyce — Tue, 16 Nov 2021 13:02:55 GMT

@brunobertels i dont think that's correct syntax where you put that flag.

count(distinct {<R1={'YES'}> + <R2={'YES'}> + <R3 ={'YES'}> * <Flag={1}>}ID)

count(distinct {<R1={'YES'}, Flag={1}> + <R2={'YES'}, Flag={1}> + <R3 ={'YES'}, Flag={1}> }ID)

Prachi_Pradip_Kulkarni — Tue, 16 Nov 2021 13:05:50 GMT

Hi brunobertels,

Thanks for reply

Not working for me

AshutoshBhumkar — Tue, 16 Nov 2021 13:07:41 GMT

Or maybe in your way

if(R1='YES' or R2='YES' or R3 ='YES' and Flag=1, Count(ID) )

Prachi_Pradip_Kulkarni — Tue, 16 Nov 2021 13:56:45 GMT

Thank You @stevejoyce ,

It's Working!🙂