Doesn't contain in Formula

[RonitGupta]

Hi, 

I want to achieve the following result -

 If [product category] = "X" AND [Line Code]="A" AND Doesn't contain([Country],"USA") THEN "NHT" ELSE Null() ENDIF

There are lot of countries in the file and next time additional country may appear in the data. 

Any suggestion to achieve this. 

[ShankerV]

Hi @RonitGupta 

I would suggest to store the value of Contain USA in another temp column and then achieve your result.

Many thanks

Shanker V

[messi007 · Accepted solution]

@RonitGupta,

Please see below :

Attached the workflow,

Regards,

[ShankerV]

Hi @RonitGupta 

Please find the expected result.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @RonitGupta 

And also if you need to add more countries in the for the checklist.

You can add like below, which will get the expected result.

Contains([Country],"USA") or
Contains([Country],"India") or
Contains([Country],"Australia")

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @RonitGupta 

Did it worked? 

If yes, Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[RonitGupta]

Hi @ShankerV,

I tried the another one which worked for me and it was shorter also.  Thanks for your support!