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

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

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

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

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