Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
If(SubStringCount(Concat(DISTINCT '|' & Band & '|'), '|' & [Postcode Band] & '|') = 1,
'YES',
'NO')
Try this
If(SubStringCount(Concat(DISTINCT '|' & Band & '|'), '|' & [Postcode Band] & '|') = 1,
'YES',
'NO')
That has worked a treat! Thanks so much Sunny
I would never have figured this one out