![Tableau In operator](https://static.wixstatic.com/media/e16c6a_a9f430759eba4fc2bec0b51e0af4401d~mv2.png/v1/fill/w_49,h_26,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/e16c6a_a9f430759eba4fc2bec0b51e0af4401d~mv2.png)
Tableau IN operator is a logical function used to test whether a specified value matches any value in a list of comma-separated values, a set, or combined fields.
(Note: The IN operator supports string, date, numeric and Boolean data types)
IN Syntax
<expr1> IN <expr2>
Where the value of <expr1> can be a set, list on values or combined fields.
Example 1
SUM([Sales]) in (2,297,202, 2,340,789, 3,456,782)
This expression returns TRUE if SUM([Sales]) matches any value in the comma-separated values
Example 2
![Example of tableau in operator](https://static.wixstatic.com/media/e16c6a_2ec5dd70ece14980b547ba2b9183abe6~mv2.png/v1/fill/w_46,h_25,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/e16c6a_2ec5dd70ece14980b547ba2b9183abe6~mv2.png)
(This calculation returns ‘Eastern Africa’ for each country matching the comma-separated values)
I hope this was somewhat helpful to you.
Thank you for reading.