Percent Change Calculation in Tableau: Formula and Example

A percent change calculation in Tableau shows how much a measure has increased or decreased relative to an earlier value. Enter the original and new values below to get the percent change; Tableau users can use the same formula in a calculated field or a table calculation.

Formula

Percent change = (new value − original value) ÷ original value × 100. In symbols, Percent change = ((N − O) / O) × 100, where O is the original value and N is the new value. Both values must use the same unit. The output is a percentage; the absolute difference is N − O, in the input values’ unit.

In Tableau, the equivalent row-level expression is ([New Value] - [Original Value]) / [Original Value]. Tableau can format that result as a percentage. If you multiply by 100 in the expression, format it as a regular number instead; doing both applies the percentage scaling twice.

Worked Example

Using the calculator’s defaults, the original value is 100 and the new value is 125:

1. Subtract the original from the new value: 125 − 100 = 25.
2. Divide the difference by the original: 25 ÷ 100 = 0.25.
3. Convert the decimal to a percentage: 0.25 × 100 = 25%.
4. The absolute difference is 25 units.

The result is a 25.00% increase. If the new value were 75 instead, the calculation would be (75 − 100) ÷ 100 × 100 = −25%, meaning a 25% decrease.

How to Calculate Percent Change in Tableau

There are two common Tableau approaches, and they answer slightly different needs. A calculated field applies the arithmetic to fields in the data. A table calculation compares values across marks in a view, such as one month against the previous month. Choose based on whether the comparison is defined by your data fields or by the arrangement of the visualization.

• For two fields on the same record: create a calculated field with ([New Value] - [Original Value]) / [Original Value]. Add it to the view and set its number format to Percentage.
• For a comparison across rows or columns in a view: use a percent-difference table calculation, or create a table calculation that subtracts the prior value and divides by it. Configure the calculation to address the date, category, or other dimension that defines the sequence.

Table calculations depend on the marks in the view. Their direction and partitioning determine which value counts as “previous.” For a monthly trend, for example, the calculation should usually address the month dimension and restart at the appropriate grouping, such as product or region. Check the result after changing dimensions, filters, or sorting, because the comparison may change when the view’s structure changes.

Reading the Result and Choosing a Comparison

A positive percentage means the new value is higher than the original; a negative percentage means it is lower. Zero means there is no change. The percentage is relative to the original value, not the new value or the absolute difference. Always identify the baseline and comparison period in a chart or label so readers know what the percentage refers to.

For example, a change from 100 to 125 is +25%, while a change from 125 back to 100 is −20%. The decrease is not −25% because the second calculation uses 125 as its baseline. Percent change is directional and depends on the starting value.

In Tableau, a built-in “percent difference” table calculation may display a ratio such as 0.25, then show it as 25% through number formatting. This is mathematically the same as multiplying the ratio by 100 and displaying the result as a number, but the two display approaches should not be combined. Decide whether you want a decimal ratio or a percentage-formatted value, then format consistently.

Common Problems and Limits

• Original value is zero: the formula divides by the original value, so percent change is undefined when it is zero. A move from zero to a positive value can be described as an absolute increase, but not as a finite percent change using this formula. Handle zero baselines explicitly in the analysis rather than presenting a misleading percentage.
• Negative baselines: the arithmetic may produce a result, but interpreting it as a conventional increase or decrease can be confusing. This often occurs with profit, balances, or signed measurements. Explain the sign and baseline, and consider showing the absolute difference alongside the percentage.
• Incorrect table-calculation direction: comparing across the wrong dimension or partition can yield plausible-looking but unrelated results. Verify which mark is treated as the prior value and where the calculation restarts.
• Rounding too early: keep full precision in the calculation and round only for display. For instance, a displayed 12.3% may be based on a more precise underlying result; later calculations should use that underlying value.
• Unequal or missing periods: “previous” may mean the previous visible mark, not necessarily the immediately preceding calendar period. Missing months, filters, or irregular dates can change what is compared. Confirm that the chosen comparison matches the question.

Percent change is useful for comparing relative movement, but it can exaggerate changes when the baseline is very small and can hide scale. For a complete view, report the original and new values, the absolute difference, and the percentage when appropriate. For comparisons involving zero or negative values, a plain difference may be more interpretable.

Frequently Asked Questions

How do I calculate percent change in a Tableau calculated field?
Subtract the original field from the new field, then divide by the original field: ([New Value] - [Original Value]) / [Original Value]. Format the result as a percentage.

Should I multiply by 100 in Tableau?
Usually, no. The formula can return a decimal ratio such as 0.25, and Percentage number formatting displays it as 25%. Multiply by 100 only if you want a value of 25 and will display it as a regular number.

What is the difference between percent change and percent difference?
Percent change compares a new value with a chosen original value, so the baseline and direction matter. “Percent difference” can refer to other comparison methods, and Tableau’s table-calculation label may describe a particular view-based comparison. Check the calculation’s definition and direction.

Why is my Tableau percent change showing null or an error?
Check whether the original value is null or zero, whether the fields have compatible data types, and whether the table calculation has valid prior marks. A zero baseline makes the standard formula undefined.

How do I calculate month-over-month percent change?
Compare each month’s measure with the preceding month using a table calculation or an explicitly defined prior-period field. Set the calculation to address months and partition it by the relevant grouping, then verify that missing months and filters do not alter the intended comparison.

Related

• Percent Reduction: Formula and Calculator
• Percent Grade Incline: Formula and Calculation
• Percent Mass: Formula and How to Calculate It

in original | Original value | - | 100 | 0
in new | New value | - | 125 | 0
out change | Percent change | % | (new - original) / original * 100 | 2
out difference | Absolute difference | - | new - original | 2