Get the "or" to work in if statement or code

[D19PAL]

Hi,

I

ID,GROUP,CODE

1,BMW,YES

1,BMW,YES

1,VW,YES

2,FORD,YES 

2,BMW,YES

2,VW,YES

3,BMW,NO

3,VW,

4,FORD,YES 

Why doesn't this work in expression or code 

If( ID = 1 and Code = 'YES' and Group = BMW or group = VW ,1) 

Thanks

[abhijitnalekar]

Hi @D19PAL ,

Change your expression as below

If( ID = 1 and CODE = 'YES' and (GROUP = 'BMW' or GROUP = 'VW') ,1)

or use this =If( ID = 1 and CODE = 'YES' and match(GROUP,'BMW','VW') ,1)

[D19PAL]

Thanks, I've done that bit now, 

Stuck here

I want to do an if statement in expression or code

The field CODE Yes or No

To pull in all or any No

To pull in yes or no

Cant pull in yes or yes's on on it's own a yes row will have to have a no row.

Thanks