Tableau practice: Arithmetic and profitability formulas
Chapter 5 · 5 questions · included in full access
Question 1 · easy
Line profit
Solve it in your browserCreate Line Profit: the profit on each order line, computed as
[Sales] - [Cost].Question 2 · easy
Row-level versus aggregate calculations
Solve it in your browserWhen does a row-level formula like
[Sales] - [Cost]execute compared to an aggregate formula likeSUM([Sales]) - SUM([Cost])?Question 3 · easy
Profit per unit
Solve it in your browserCreate Profit per Unit: the profit divided by units sold on each order line:
([Sales] - [Cost]) / [Units].Question 4 · medium
Net revenue
Solve it in your browserCreate Net Revenue: the sales amount after factoring in the negotiated discount rate:
[Sales] * (1 - [Discount]).Question 5 · easy
Safe division in Tableau
Solve it in your browserWhat does Tableau return if a calculated field attempts to divide a number by zero or divides a Null value?
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing