Forum Discussion

Likhitha's avatar
Likhitha
Icon for Helper IV rankHelper IV
6 years ago
Solved

Doubt regarding data match between 2 different tables

Hello All,

I'm having 2 different tables A and B  with one common column "Product",I want to create a column in Table-A like Exclude and Include.

Exclude mean if Product in Table-B shouldn't be considered for calculation in Table -A or else it is Include .

For the above condition I created a column like

Excl/Incl=if (Tbl-A[Product] in DISTINCT(Tbl-B[Product]),"Exclude","Include")

For Example if my Tbl-B has 2 Products and Tbl-A has 6  Products my Exclude selection should show count as 4 and include should show 6.

But my condition gives Exclude as 2 and include as 4.

How to sort it out?

1 Reply