Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can use Set analysis instead of if. Try this:
{<Name = {'Be*'}>}
You mean like this:
IF (FA_Number = 'E*',1,0)
doesn't work
What about this:
If(WildMatch(FA_Number, 'E*'), 1, 0)
This works!
Thank you!