Tableau Calculated Fields Tutorial: How to Create & Syntax

Calculated fields extend your source without ETL — the analyst's way to add Cost, margin, or rounded metrics that the source query missed. Using Superstore data from script 06, this guide moves from creation to aggregation to formatting, with syntax you can copy. For pill context see Tableau Data Types and Roles and for connection see Tableau Connecting Data Sources.

How do you create a calculated field?

Right-click > Create > Calculated Field Tableau Help: Create Calculated Field. Steps:

1. In Data pane, right-click a measure or empty area > Create Calculated Field.
2. Name it (e.g., Cost).
3. Type the formula using [Field] brackets and functions.
4. Click Validate; green check means syntax is valid.
5. Drag the new field (icon shows = #) to Rows, Columns or Marks.

The editor's autocomplete and function pane reduce typos — use them instead of typing freeform.

What is the Cost example — row vs aggregate?

Row-level and aggregate forms answer different questions Tableau Help: Aggregation.

// Row-level: computes per underlying row
[Sales] - [Profit]            // cost per row (then aggregated by Tableau on drop)
 
// Aggregate: computes after grouping by view
SUM([Sales]) - SUM([Profit])  // total sales minus total profit for the viz grain

If your view is by Category, the aggregate form returns one Cost per Category. The row-level form is aggregated again by Tableau (default SUM). Both are valid, but mixing SUM([Sales]) - [Profit] triggers "Cannot mix aggregate and non-aggregate" — a classic interview trap see LOD guide.

Toggle Analysis > Aggregate Measures to see granular vs summarised behaviour.

How do MIN and MAX define ranges?

Bounds per partition Tableau Help: Aggregation.

MIN([Sales])
MAX([Sales])
MIN([Order Date])

Drag Product Name to Detail and add MIN([Sales]) and MAX([Sales]) to Tooltip: you now show per-product transaction bounds. In the script at 4:28, MIN/MAX are used to spot outlier products with unusually high maximum sales.

Use with categorical filters: per Region, MAX reveals the top transaction that drives the SUM — useful before you aggregate to Tableau Table Calculations.

How do CEILING and FLOOR clean reporting?

Standardise decimals for stakeholders Tableau Help: Number Functions.

CEILING([Profit])   // 681.76 -> 682
FLOOR([Profit])     // 681.76 -> 681
ROUND([Profit], 0)  // nearest integer

Script demo at 7:45 rounds reporting values to integers. Use the Format pane after calculated field creation to set custom decimal display — but prefer calculation-level rounding when the value will be exported to CSV.

Common errors and quick reference

Next: make those fields interactive with Tableau Parameters Dynamic Filters Top-N, master the comprehensive framework in our Tableau Complete Guide, or control grain via Tableau Level of Detail Expressions.