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

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

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

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

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