Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Shamit,
Try like,
If(Not WildMatch([Supplier PO], 'RA*'), [Supplier PO])
OR
If( Not [Supplier PO] Like 'RA*' , [Supplier PO])
Hi Shamit,
Try like,
If(Not WildMatch([Supplier PO], 'RA*'), [Supplier PO])
OR
If( Not [Supplier PO] Like 'RA*' , [Supplier PO])
Thanks Tamil,
That worked.
Shamit
=If(Index([Supplier PO], 'RA') = 0, [Supplier PO])
Result: