Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to highlight the background colour of a dimension value when it includes the word 'primary' e.g. Williamston Primary School. I have been trying to change the background colour on my dimension using the following expression -
=If([School Name]='*Primary', Yellow(),)
But it doesn't work. What should I use instead of the *
Thanks
Greg
May be you need an * at the end too?
=If(WildMatch([School Name], '*Primary*'), Yellow())
May be use WildMatch
=If(WildMatch([School Name], '*Primary'), Yellow())
Thanks but it didn't work.
May be you need an * at the end too?
=If(WildMatch([School Name], '*Primary*'), Yellow())
Thanks. That worked!
Superb