Contains or Starts with ??

[sculptorlv]

Hello!

Please help with the expression.

I have result columns with Names.

Then I use expression in Pivot Table. And I have to made IF expression. In this IF I should fins all rows, where Name starts with tow letters "Be".

Which function I have to use?

Thank you.

[sunny_talwar]

You can use Set analysis instead of if. Try this:

{<Name = {'Be*'}>}

[sculptorlv]

You mean like this:

IF (FA_Number = 'E*',1,0)

doesn't work

[sunny_talwar · Accepted solution]

What about this:

If(WildMatch(FA_Number, 'E*'), 1, 0)

[sculptorlv]

This works!

Thank you!