How to get results from IF SEARCH

[Anonymous]

I am looking to get results for if a country has a certain product (lets say that product is called "product x). For example: I have a list of all the products in Canada. Canada has product x but also has other products. when I use the below IF statement I get a bunch of "YES" and "-". Is it possible to have a seperate table with a column that says " If Canada has the product x only "YES" will appear" as a single row. I am looking to do this for all countries. In the end each country will have its own single row of either "Yes" or "-" meanign that country either has the product or not.

"column name" =

IF (

SEARCH ( "product x", products_data_matrix[type],, 0 ) > 0,

"YES",

"-"

)

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

1, Create a calculated column in 'products_data_matrix' table.

2, Create a calculated table.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

What problem do you face with this formula?  Could you share some data, show the result of your formula and also show the expected result.