Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Together,
I am using the below expression, it works fine.
Now I want to show the Material which does not contain the Text = *Spare Part* in the first 50 characters as well.
If *Spare Part appears in the first 50 characters it should not appear in the list.
=Count( {Product={'AW'},[Status]*={'Good'},Text-={"*Spare Part*"}>+<[Status]*={'Very Good'},Text-={"*Spare Part*"}>}Material)
Thanks for your help.
Try like:
Text={"=WildMatch(Left(Text,50), '*Spare Part*') "}
Now and/or combination is up to you.
Thanks for your help.