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

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

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

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

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