Exclude value from a dimension

[shamitshah]

Hi,

I have the dimension Supplier PO and it has values e.g. 123563P, RA-12345-0134

I want to exclude all the RA values from the dimension. I tried the following as a calculated dimension, but it does not seem to work.

=If(not Match([Supplier PO], 'RA*'), [Supplier PO])

Any ideas?

Thanks

Shamit

[tamilarasu · Accepted solution]

Hi Shamit,

Try like,

If(Not WildMatch([Supplier PO], 'RA*'), [Supplier PO])

OR

If( Not [Supplier PO] Like 'RA*' , [Supplier PO])

[shamitshah]

Thanks Tamil,

That worked.

Shamit

[MindaugasBacius]

=If(Index([Supplier PO], 'RA') = 0, [Supplier PO])

Result: