Arithmetic calculations in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is an arithmetic calculation in Tableau?

An arithmetic calculation in Tableau is a formula that uses basic math operations like addition, subtraction, multiplication, and division to create new values from existing data fields.

beginner

How do you write a simple addition calculation in Tableau?

You write it by using the plus sign (+) between two fields or numbers, for example: [Sales] + [Profit] adds the Sales and Profit values.

beginner

Which symbol is used for multiplication in Tableau calculations?

The asterisk (*) symbol is used for multiplication. For example, [Quantity] * 2 doubles the Quantity value.

intermediate

What happens if you divide by zero in a Tableau calculation?

Dividing by zero causes an error or returns a null value. It's best to check for zero before dividing to avoid errors.

intermediate

How can you combine multiple arithmetic operations in one Tableau calculation?

You can combine them using parentheses to control the order, like ([Sales] - [Cost]) / [Cost] to calculate profit margin.

Which symbol is used for subtraction in Tableau calculations?

A +

B -

C *

D /

The minus sign (-) is used for subtraction in Tableau calculations.

What will the calculation [Sales] / [Quantity] do?

A Add Sales and Quantity

B Multiply Sales by Quantity

C Divide Sales by Quantity

D Subtract Quantity from Sales

The slash (/) divides Sales by Quantity.

How do you ensure the correct order of operations in a Tableau calculation?

A Use parentheses

B Use square brackets

C Use curly braces

D Use quotation marks

Parentheses control the order of operations in calculations.

What result do you get if you multiply [Price] by 0?

A Zero

B Null

C Price value

D Error

Any number multiplied by zero equals zero.

Which of these is NOT a valid arithmetic operator in Tableau?

A -

B +

C *

D =

The equals sign (=) is not used as an arithmetic operator in Tableau calculations.

Explain how to create a calculation in Tableau that subtracts Cost from Sales and then divides by Cost.

Think about the order in which math operations happen.

Describe what happens if you try to divide a number by zero in a Tableau calculation and how to avoid it.

Consider safe math practices in calculations.