From the course: Tableau 10: Mastering Calculations

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create IF THEN ELSE and ELSE IF expressions

Create IF THEN ELSE and ELSE IF expressions - Tableau Tutorial

From the course: Tableau 10: Mastering Calculations

Start my 1-month free trial

Create IF THEN ELSE and ELSE IF expressions

“

- [Instructor] Some calculations are straightforward, perhaps multiplying one value by another or adding a data series to find a total. Many other calculations are more complex and in some cases, require different formulas based on the values you're summarizing. In this movie, I'll show you how to use IfThen expressions to perform conditional calculations based on rules you define. My sample file is the IfThen workbook, and you can find it in the Chapter05 folder of the exercise files collection. I have the total value of orders placed by my hotel. As you can see, I have them sorted by order ID with the value next to it. What I'd like to do is to determine and indicate whether a discount might be available. The rule that I want to use is that any order with a total value of more than $300 would be able to receive the discount and any below it would not. And I only want to display Discount available if the order does qualify. To do that, I need to create a calculated field so I'll go…

Contents