# Tableau Numeric Calculations

In Tableau, numeric calculations are done using a wide range of inbuilt functions available in the formula editor.

Let’s see how to apply calculations to the fields. The calculations are simple as subtracting the values of two fields or using an aggregate function to a single field.

Here are the steps to create a calculation field and use numeric functions in it.

## How to Create a Calculated Field

- After connecting to a data source such as
**Sample-Superstore**. - Go to
**Analysis**menu. - And click on
**Create Calculated**Field as shown in the below image.

## Calculation Editor in Tableau

The above process opens a calculation editor which lists all the functions available in Tableau.

You can change the dropdown value and only see the related functions to numbers.

## Create a Formula

o visualize the difference between **Profit** and **Discount** for different shipping mode of the products, create a formula that subtracts the **Discount** from the **Profit** , as shown in the below image, and the name of this field is **profit_n_discount** .

## Using the Calculated Field

The above-calculated field can be used in the view by dragging it to the Rows shelf as shown in the below screenshot.

It produces a bar chart that shows the difference between profit and discount for different shipping modes.

## Applying the Aggregate Calculations

You also can create a calculated field using an aggregate function.

- First, create AVG (sales) values for different ship mode.
- Then, Write the formula in the calculation editor as shown in the below screenshot.

- Click
**OK**and dragging the**Avg_Sales**field to the Rows shelf, then you get the following view.