SubstringCount with GetFieldSelection

[spikenaylor1]

Hi all

My current expression is

If(substringCount( GetFieldSelections(Batches_to_Include,'|',100) & Batch)>0,vHighLightNewBatchesColour,LightGray())

my Batches_to_Include field contains 

AA1234

AA5678

AB1234

AB5678

My Batch Field contains

the same batches and thus the expression finds all the same batches and colours accordingly

However, if I have batch in the Batch Field called AC3564, AB1234, the expression doesn't find AB1234

How can I incorporate a Like into the expression , so the expression will look for *AB1234* in the Batch Field.

Regards

Many thanks for looking

[Dalton_Ruer]

What is that you are trying to accomplish by using the expression? By default anything not selected will not be shown in any chart. You would need to use some Set Analysis to get data you haven't selected to be visualized.