5 Replies Latest reply on Mar 16, 2016 6:34 AM by Shinichiro Murakami

# Problem in Contains Function

Hi friends

I need to show the values which should be filtered by two columns

And  more over that should be in calculated Column

I am using this below expression but I didn't get my result.

IF CONTAINS ([RESOLUTION],"HIGH") AND CONTAINS ([TYPE],"COMPLAINT") THEN  [NAME]  END

This expression give output as values of NAME where [Resolution] = "High" it didn't consider [TYPE] can you please help me  on this how can I write condition by using two columns and show the Single value

• ###### 1. Re: Problem in Contains Function

You may need

IF CONTAINS ([RESOLUTION],"HIGH") or CONTAINS ([TYPE],"COMPLAINT") THEN  [NAME]  END

?according to your comment?

In this case resolution = high line item "and" type = complaint line item should be picked up.

your formula itself looks correct, another possbility is

IF CONTAINS ([RESOLUTION],"HIGH") and CONTAINS (upper([TYPE]),"COMPLAINT") THEN  [NAME]  END  ??

Thanks,

Shin

• ###### 2. Re: Problem in Contains Function

Thanks for your reply Murakami I used the 2nd expression also what  you replied me in this thread. But I didn't get the proper result

I got the Result which depends on [Resolution] alone, but it's not depend on [TYPE] is there any other way to do please help me on this

whether it is possible to make the above query in a Calculated column

• ###### 3. Re: Problem in Contains Function

Hi Abhinesh,

Please use the following formula.

IF CONTAINS ([RESOLUTION],"HIGH")==True AND CONTAINS([TYPE],"COMPLAINT")==True

THEN  [NAME]

END

Contains returns the true or false as a part of evaluation which you were not checking in the IF condition.

Please let me know if you need any more clarification on this.

• ###### 4. Re: Problem in Contains Function

Are you able to attach your packaged workbook.

Only sample is OK.

Thanks,

Shin

• ###### 5. Re: Problem in Contains Function

Your calculation formula Working for me.

Thanks,

Shin

9.0 attached