Arithmetic calculations in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate the sum of Sales and Profit.

Tableau

SUM([Sales]) [1] SUM([Profit])

Drag options to blanks, or click blank then click option'

A*

B-

C+

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using multiplication (*) instead of addition (+).

Using division (/) which is incorrect here.

In Tableau, the plus sign (+) is used to add two measures together.

2fill in blank

medium

Complete the code to calculate the average profit margin as Profit divided by Sales.

Tableau

SUM([Profit]) [1] SUM([Sales])

Drag options to blanks, or click blank then click option'

A/

B+

C-

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using addition (+) instead of division (/).

Using multiplication (*) which changes the meaning.

The division operator (/) divides Profit by Sales to get the profit margin.

3fill in blank

hard

Fix the error in the calculation to find the difference between Sales and Discount.

Tableau

SUM([Sales]) [1] SUM([Discount])

Drag options to blanks, or click blank then click option'

A+

B/

C*

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using addition (+) which adds instead of subtracts.

Using multiplication (*) which is incorrect here.

The minus sign (-) subtracts Discount from Sales to find the difference.

4fill in blank

hard

Fill both blanks to calculate the total revenue after applying a 10% tax on Sales.

Tableau

SUM([Sales]) [1] (SUM([Sales]) [2] 0.10)

Drag options to blanks, or click blank then click option'

A+

B-

C*

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Subtracting tax instead of adding it.

Dividing instead of multiplying for tax calculation.

First, calculate 10% of Sales by multiplying by 0.10, then add it to Sales to get total revenue after tax.

5fill in blank

hard

Fill all three blanks to calculate the profit ratio as Profit divided by (Sales minus Discount).

Tableau

SUM([Profit]) [1] (SUM([Sales]) [2] SUM([Discount]) [3] 1)

Drag options to blanks, or click blank then click option'

A+

B/

C-

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using addition instead of subtraction for Discount.

Dividing inside the parentheses incorrectly.

Profit ratio is Profit divided by (Sales minus Discount times 1). The multiplication by 1 keeps the expression valid.