Doesn't contain in Formula

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.

Custom Tools

Accepted answers

Please see below :

Attached the workflow,

Regards,

Test_20221227.yxmd

All comments

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

Many thanks

Shanker V

Please see below :

Attached the workflow,

Regards,

Test_20221227.yxmd

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

Doesn't contain in Formula.yxmd

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

Doesn't contain in Formula.yxmd

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703