Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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