Tableau Operators: Arithmetic, Comparison and Logical

# Tableau Operators: Arithmetic, Comparison and Logical

3 mins read581 Views Comment
clickHere
Vikram Singh
Assistant Manager - Content
Updated on Apr 10, 2022 21:17 IST

In this article we will discuss different operators in Tableau like arithmetic, comparison and logical operators.

## Introduction

In this article, we will discuss operators in Tableau.

In computer programming operators are the symbols that are used to perform specific mathematical or logical manipulations.

In Tableau, we mainly have 3 types of operators let’s discuss them briefly

## Table of Content:

### Arithmetic Operators:

An arithmetic operator is a mathematical function that takes two operands and performs calculations on them.

The basic arithmetic operations are addition (+), subtraction (-), multiplication (*), division (/), modulo (%), power (^).

When the + operator is applied, it means:

• addition when applied to numbers
• Eg: 5 + 5 = 10
• Concatenation when applied to the string
• ‘abc’ + ‘def’ = ‘abcdef’
• Add number of days to a date, when applied to dates
• #April 4, 2022# + 6 = #April 10, 2022#
• Subtraction (-)

When the – operator is applied, it means:

• Subtraction when applied to a number
• 5 – 4  = 1
• Negation when applied to an expression
• – (5+5) = -10
• subtract the number of days to a date, when applied to dates
• #April 4, 2022# – 2 = #April 2, 2022#
• #April 4, 2022# – #April 2, 2022#  = 2
• Multiplication (*)

When the * operator is applied, it means numeric multiplication.

• 5 * 4 = 20
• 9 * 9 = 81
• Division (/)

When the / operator is applied, it means numeric division.

• 5 / 2 = 2.5
• 20 / 2 = 10
• Modulo (%)

The modulo operator % returns the remainder in the division.

• 7 % 2 = 1
• 35 % 5 = 0
• Power (^)

The power operator ^ means, raised a number to a specific power.

• 2^3 = 8
• 5^4 = 625

## Comparison Operator

Comparison operators are used for the comparison of expression. Operators are used two compare numbers, dates, strings, and return a boolean.

Some of the comparison operators are:

## Logical Operators

Logical operators have only 3 operators: AND, OR, NOT.

• AND Operator
• It returns TRUE only if both the conditions are TRUE
• It returns FALSE if either one or both the conditions are FALSE
• OR Operator
• It returns FALSE only if both the conditions are FALSE
• It returns TRUE if either one or both the conditions are TRUE
• NOT Operator
• It returns TRUE if the following condition is FALSE
• It returns FALSE if the following condition is TRUE

## Order Precedence

Conclusion

In this article, we have discussed operators in Tableau: Arithmetic, logical and comparison operators.

This article is a part of a complete tutorial of Tableau, focusing on Tableau certified data analysts and tableau desktop specialists.

Through a series of articles, we will cover all the topics in-depth with examples.

Data Types in Tableau
Tableau supports 7 types of data types String values, Date values, Date & Time values, Numeric values, Boolean values, Geographical values, Cluster or mixed values.
Dimension and Measure in Tableau
Tableau supports seven different data types and it tableau automatically assigns a data type and role to each column.
In this article, we will discuss one of the important concepts...read more
Data Aggregation in Tableau
In this article, we discussed different aggregation functions in tableau, how to change the aggregation of a measure in a view and how to disaggregate the data.