Tableau Operators: Arithmetic, Comparison and Logical

# Tableau Operators: Arithmetic, Comparison and Logical

clickHere
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 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.

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. 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.

clickHere

Vikram has a Postgraduate degree in Applied Mathematics, with a keen interest in Data Science and Machine Learning. He has experience of 2+ years in content creation in Mathematics, Statistics, Data Science, and Mac... Read Full Bio

## Trending Management Courses  Tableau Tutorial for Beginners
UDEMY 4.5 Complete VMWare vSphere ESXi and vCenter AdministrationComplete VMWare vSphere ESXi and vCenter Administr...
UDEMY 4.9 ## Top Picks & New Arrivals        