---
schema_version: "1"
id: 8a4784cab140995d95ce7f75230ccc7b5f9216f7f0cd10a8361bbc76b00150da
title: Create a Simple Calculated Field
collection: tableau
version: current
locale: en-us
portal_url: https://docs.salesforce.com/tableau/current/en-us/public/desktop/calculations_calculatedfields_formulas.md
canonical_url: https://help.tableau.com/current/public/desktop/en-us/calculations_calculatedfields_formulas.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 8f9fccbad2fbe329612da2533c5598ad89f603f847d8002576de1228a804b6f4
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/public/desktop/en-us/functions_operators.htm) and [Functions in Tableau](https://help.tableau.com/current/public/desktop/en-us/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/public/desktop/en-us/calculations_calculatedfields_create.htm)

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

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

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

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