Help with If expression/statement

[jamelmessaoud]

Hi guys,

Not sure if this is possible or not?

I would like to create an expression based on selections made from a filter pane.

Basically i have a filter pane with a field called "Band" and I've created the following if expression if(Band = [Postcode Band],'YES','NO').  

This will work if a single selection is made but when multiple selections are made it doesn't work.  Ideally I would like to see "YES" if any selection of band is made.  For example choose bands 1 3 and 5 then the Yes will appear next to those postcode bands.

Hopefully this makes sense.  I've just to explain this in the simplest form! 

Thanks
J

[sunny_talwar · Accepted solution]

Try this

If(SubStringCount(Concat(DISTINCT '|' & Band & '|'), '|' & [Postcode Band] & '|') = 1,
'YES',
'NO')

[jamelmessaoud]

That has worked a treat! Thanks so much Sunny 

I would never have figured this one out