---
schema_version: "1"
id: 22727e4b52ee33f65a50531c7e43fc7a5c5aea7e5252049d602176e30cc417e6
title: Create a Simple Calculated Field
collection: tableau
version: current
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/current/en-gb/pro/desktop/calculations_calculatedfields_formulas.md
canonical_url: https://help.tableau.com/current/pro/desktop/en-gb/calculations_calculatedfields_formulas.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 3e0741b9f3ea37a613580931eb38e4cb61c67cb00e68066b6c31a832fce4e6ee
description: Create a simple calculated field, such as Profit Ratio, using a formula from existing fields.
---
[Skip to main content](#main-content)

# Create a Simple Calculated Field

Sometimes your data source does not contain a field (or column) that you need for your analysis. For example, your data source might contain fields with values for Sales and Profit, but not for Profit Ratio. If this is the case, you can create a calculated field for Profit Ratio using data from the Sales and Profit fields.

This topic demonstrates how to create a simple calculated field using an example.

## Step 1: Create the calculated field

1. In a worksheet in Tableau, select Analysis \> Create Calculated Field.
2. In the Calculation Editor that opens, give the calculated field a name. In this example, the calculated field is called **Profit Ratio**.

## Step 2: Enter a formula

1. In the Calculation Editor, enter the following formula:
    
    SUM(\[Profit\])/SUM(\[Sales\])
    
    Formulas use a combination of functions, fields and operators. To learn more about creating formulas in Tableau, see [Writing Calculations in Tableau](https://help.tableau.com/current/pro/desktop/en-gb/functions_operators.htm) and [Functions in Tableau](https://help.tableau.com/current/pro/desktop/en-gb/functions.htm).
2. When finished, click **OK**. The new calculated field is added to the Data pane with an = in front of the data type icon to indicate it's a calculated field.

You are now ready to use the calculated field in the view.

## Check your work! Watch how to create a simple calculated field in action:

## See Also

[Get Started with Calculations in Tableau](https://help.tableau.com/current/pro/desktop/en-gb/calculations_calculatedfields_create.htm)

[Writing Calculations in Tableau](https://help.tableau.com/current/pro/desktop/en-gb/functions_operators.htm)

[Functions in Tableau](https://help.tableau.com/current/pro/desktop/en-gb/functions.htm)

[Create Level of Detail Expressions in Tableau](https://help.tableau.com/current/pro/desktop/en-gb/calculations_calculatedfields_lod.htm)

[Transform Values with Table Calculations](https://help.tableau.com/current/pro/desktop/en-gb/calculations_tablecalculations.htm)