# Tableau Operators

Tableau provides basic operators to perform the calculations such as Arithmetic Operation, Logical operation, Relational Operation, and General Operations. We can use these operators to perform the analysis on various types of data to get the value.

The following is the list of Tableau Operators supported by Tableau.

## Tableau Operators Types

Let us see each operator in detail in the below section.

## 1. Tableau Arithmetic Operators

Tableau Arithmetic Operators are used to perform the Arithmetic operation on numeric data. The following is the list of Arithmetic Operators supported in Tableau.

Operator_Name Operator_Description Example
*(Multiplication) This operator is used to perform the Numeric multiplication. 500*20 = 10000
/(Division) This operator is used to perform the Numeric division 50/3 = 16.66666
%(modulo) This operator is used to provide the Reminder of numeric division 13 % 2 = 1
^(power) This operator is used to Raised to the power 2^4 = 16

## 2. Tableau Relational Operators

Tableau Relational operators are used to perform the comparison of a numeric, character string, or logical data and return the result either true or false that is used in deciding Tableau. Following is the list of Tableau Relational operators.

Operator_Name Operator_Description Example
= = or = (Equal to) This operator is used to compare two string/number/date to check equality and return Boolean value TRUE if the values are equal otherwise it will return FALSE. ‘World’ = ‘Hello World’ 10 = 100/ 5
!= or <> (Not equal to) This operator is used to compare two string/number/date to check none quality and return Boolean value TRUE if the values are equal otherwise it will return FALSE. ‘Success’ <> ‘Fail’ 45 != 45 / 2
> (Greater than) This operator is used to compare two string/number/date to check the first argument is greater than second argument and return Boolean value TRUE if it qualifies otherwise it will return FALSE. [Sales] > 60000 [Category] > ‘W’ [Sales date] > #Oct 19, 1990#
< (Less than) This operator is used to compare two string/number/date to check the first argument is smaller than second argument and return Boolean value TRUE if it qualifies otherwise it will return FALSE. [Sales] > 60000 [Category] <‘W’ [Sales date] > #Oct 19, 1990#

## 3. Tableau Logical Operators

The Tableau Logical Operators are used to perform the logical operations and return the Boolean result TRUE or FALSE. Following is the list of Logical Operators supported in Tableau.

Operator_Name Operator_Description Example
AND The AND operator will return TRUE if both expression values are present otherwise it will return FALSE. [Sales Date] > #Oct 5, 2000# AND [Sales_Profit] > 20000
OR The OR operator will return TRUE if any of the expression values are present. If expression values are not matching at all then it will return the value FALSE. [Sales Date] > #Oct 5, 2000# OR [Sales_Profit] > 20000
NOT This operator is used to ignore the Boolean expression which is presented after it. NOT [Sales Date] > #Oct 5, 2000#

## 4. Tableau General Operators

The General Operators are used to perform the addition of two numbers, the addition of two strings, the addition of two dates, similarly subtraction of two numbers, and so on. The following is the list of general operators supported in Tableau.

Operator_Name Operator_Description Example
+(Addition) This operator is used to add two numbers, strings, dates, and so on. 100 + 400 EmpName + EmpID #Oct 14, 2000# + 14 = #Oct 28, 2000#
–(subtraction) This operator is used to subtract two numbers, subtract the dates, and so on. 100 + 400 #Oct 14, 2000# - 1 = #Oct 13, 2000#

## 5. perator Precedence

The Operator Precedence is used to decide the order in which they are going to evaluate. The same order precedence is evaluated from left to right in the formula also the inner parentheses are evaluated before the outer parentheses.

The following is the list of Tableau Operator Precedence.

Operator_Precedence Operator_Name
1 –(negate)
2 ^(power)
3 *, /, %
4 +, –
5 ==, >, <, >=, <=, !=
6 NOT
7 AND
8 OR