How can I use OR logic

StavrosMcGillicuddy — Sat, 11 Dec 2021 14:27:52 GMT

I have a products table and a Company table.

I need to count the companies that have any of the selected products. ("Product 1" or "Product 2" or "Product 3")

I thought about using a table chart but the default logic there is all (must have "Product 1" and "Product 2" and "Product 3")

Re: How can I use OR logic

Saravanan_Desingh — Sat, 11 Dec 2021 15:12:06 GMT

Try something like this,

Count(DISTINCT If(WildMatch(Products,'Product 1','Product 2','Product 3'),Companies))