How to Multiply in Tableau Calculated Field

Performing calculations is at the heart of any meaningful data analysis, and multiplying values to get new insights is one of the most common operations you'll need. Tableau’s calculated fields make this easy, allowing you to create new data from your existing fields, from calculating revenue to projecting future sales. This tutorial will walk you through exactly how to use multiplication in Tableau, starting with the basics and moving to more dynamic, real-world examples.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is a Tableau Calculated Field?

Think of a calculated field as a new column you add to your data source, except this column doesn’t exist in the original file - you create it yourself inside Tableau. Its purpose is to give you flexibility. Calculated fields let you transform your data on the fly, create new metrics, segment your customers in unique ways, or clean up messy data points.

For example, your data might contain Quantity Sold and Price Per Item, but not a column for Total Revenue. Instead of going back to your source spreadsheet or database to add it, you can create a calculated field directly in Tableau to multiply these two values. This is not only faster but also makes your analysis more dynamic. It's a foundational feature for moving beyond simple visualizations to build powerful, insightful dashboards.

The Basics: How to Multiply in Tableau

At its core, multiplication in Tableau is straightforward - it uses the asterisk symbol (*), just like popular spreadsheet software like Excel or Google Sheets.

The Multiplication Operator: Asterisk (*)

The syntax is simple: you place the asterisk between the two values or fields you want to multiply. These values can be existing fields from your data source, static numbers, or even the results of other functions.

For example, a formula to calculate an item's total line revenue would look like this:

[Quantity] * [Unit Price]

Or, if you wanted to see what sales would look like with a 15% increase, you could multiply by a static number:

[Sales] * 1.15

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step: Creating Your First Multiplication Calculation

Let's walk through creating a calculated field to project a 10% increase in sales using the Sample - Superstore data set that comes with Tableau Desktop.

1. Connect to Data: Open Tableau and connect to the "Sample - Superstore" data source.
2. Build a Simple View: Drag Category to the Rows shelf and Sales to the Columns shelf to create a simple bar chart showing sales by category.
3. Create the Calculated Field: In the top menu, go to Analysis > Create Calculated Field. Alternatively, you can right-click anywhere in an empty space of the "Data" pane on the left and select Create Calculated Field....
4. Name Your Field: A dialog box will open. First, give your new field a descriptive name. Let's call it "Projected Sales (10% Increase)".
5. Write the Formula: In the large text box, type your multiplication formula. To calculate a 10% increase, we multiply the original sales by 1.10.

[Sales] * 1.10

Notice that as you start typing [Sales], Tableau will suggest the field, which you can select from the dropdown. This helps avoid typos. At the bottom of the dialog box, you should see a message that reads, "The calculation is valid."

1. Apply the Calculation: Click OK. Your new field, "Projected Sales (10% Increase)," will now appear in your Data pane under the "Measures" section.
2. Add it to Your View: Drag your new calculated field from the Data pane onto the Columns shelf, next to the original SUM(Sales) pill. You will now see two bar charts, one showing current sales and one showing the projected sales values.

Practical Examples of Multiplication in Action

Basic multiplication is useful, but the real power comes from applying it to solve specific business problems. Here are a few common scenarios where multiplication is essential.

Example 1: Calculating Total Revenue

A classic e-commerce or retail use case. Your data has Quantity of units sold and the Price of each unit, but no Total Revenue column. You need this to analyze performance.

• Calculated Field Name: Total Revenue
• Formula: [Quantity] * [Price]

This creates a row-level calculation that computes the total revenue for every single transaction in your dataset. You can then aggregate this new field to see total revenue by region, product, or sales representative.

Example 2: Applying a Sales Discount

Imagine you have a List Price for products and a Discount percentage (stored as a decimal, e.g., 0.15 for 15%). To find the final price paid by the customer, you need to calculate the value after the discount is applied.

• Calculated Field Name: Final Sale Price
• Formula: [List Price] * (1 - [Discount])

The logic here is that (1 - [Discount]) calculates the portion of the price that remains. For a 15% discount, this expression becomes (1 - 0.15), which equals 0.85. The formula then multiplies the list price by 85% to get the final sale price.

Example 3: Currency Conversion

When working with global sales data, you often need to standardize everything to a single currency for accurate reporting. Suppose your primary sales data is in USD, and you need to convert it to Euros (EUR) for your European office.

• Calculated Field Name: Sales (EUR)
• Formula: [Sales (USD)] * 0.93

In this example, 0.93 is the conversion rate. Pro tip: For more flexibility, you can create a Tableau Parameter for the conversion rate. This allows users to input the current rate directly on the dashboard without you having to edit the calculation itself.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Combining Multiplication with Other Tableau Functions

To take your analysis to the next level, you can nest multiplication within more complex calculations, such as aggregations and conditional logic (IF statements).

Multiplication with Aggregate Functions like SUM()

It's important to understand the difference between row-level calculations and aggregate calculations. A row-level calculation like [Sales] * [Quantity] is performed for every row in your data. An aggregate calculation like SUM([Sales]) * SUM([Quantity]) is performed on the aggregated values for whatever dimension is in your view.

Look at this distinction:

• SUM([Sales] * [Quantity]): This is almost always what you want. Tableau first multiplies the sales and quantity for each individual row, and then it sums up those results. This correctly calculates a total value.
• SUM([Sales]) * SUM([Quantity]): This is different and usually incorrect. Tableau first sums all sales in the view and then separately sums all quantities, and afterward multiplies those two big totals together. This will produce a massively inflated number.

Always consider where in the order of operations you want your multiplication to happen: before or after aggregation.

Using Multiplication Inside an IF Statement

A very common need is to apply different logic based on some condition. Let's say you want to apply a special 25% discount for anyone who is a member of your loyalty program, while everyone else gets a standard 5% discount.

• Calculated Field Name: Tiered Discount Price

IF [Customer Status] = "Member" THEN
    [Sales] * 0.75
ELSE
    [Sales] * 0.95
END

This calculated field checks the "Customer Status" for each row. If the status is "Member," it multiplies the Sales by 0.75 (a 25% discount). For every other customer, it multiplies Sales by 0.95 (a 5% discount). This allows you to build complex business rules and segmentation directly into your analysis.

Troubleshooting Common Errors

While multiplication is straightforward, you can sometimes run into errors based on your data. Here’s how to handle the most common ones.

1. Data Type Mismatches

You cannot multiply a number by a text string. If you try to create a formula like [Sales] * "US" you will immediately get an error. Both fields in a multiplication must be numeric (e.g., Integer, Decimal). If you have a numeric value stored as a string (indicated by the "Abc" icon in the Data pane), you can convert it using functions like INT() for whole numbers or FLOAT() for decimals. For example: FLOAT([Price String]) * [Quantity].

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Null Values

In data calculations, any operation involving a NULL value results in NULL. For example, if you have a price of $100 but the quantity is NULL, the result of $100 * NULL is NULL, not zero. This can cause entire rows or totals to disappear from your view. To fix this, use the ZN() function, which stands for "Zero Null". The ZN() function converts any NULL value to a 0.

ZN([Sales]) * ZN([Quantity])

This ensures that if either Sales or Quantity is null, it is treated as a zero for the calculation, preventing the null from spreading.

3. Aggregate vs. Non-Aggregate Errors

This is a frequent point of confusion in Tableau. The error "Cannot mix aggregate and non-aggregate arguments..." happens when you try to multiply an aggregated value with a row-level value. For example:

SUM([Sales]) * [Profit Ratio]

Here, SUM([Sales]) is an aggregate (because SUM is an aggregate function), but [Profit Ratio] is a row-level, non-aggregate value. Tableau doesn't know how to multiply a single aggregated value against many individual row-level values. To fix this, you must aggregate both sides of the calculation.

SUM([Sales]) * AVG([Profit Ratio])

By aggregating [Profit Ratio] (using AVG, MIN, MAX, or ATTR), you are now working with two values at the same level of detail, and the calculation will be valid.

Final Thoughts

Multiplication is a fundamental building block of data analysis in Tableau. Using the simple * symbol in a calculated field, you can generate everything from simple revenue metrics to complex, conditional KPIs. Being able to multiply at the row level or with aggregated data gives you the control needed to turn raw numbers into valuable business insights.

Learning the syntax for calculated fields is often the biggest hurdle teams face when trying to build their own reporting. With tools like Graphed, you don't even need to think about it. Since we let you build dashboards using natural language, you can skip writing formulas entirely. You can just ask something like, "Show me our revenue which we calculate by multiplying the quantity sold by the unit price" and we instantly handle the calculation and visualization for you, connecting live to your data so it's always up to date.