...

You can perform the following calculations on all values in the column:

To apply a numeric calculation to one column, follow these steps:

Click the drop-down button next to the column name.

Click

**Calculate**,**and then select the numeric function you want to perform.****Some functions require a decimal value to complete the calculation. For example, if you select Subtract, enter the number to subtract from each row.****You can choose to create a new column with the results of numeric calculation or overwrite the values in the current column.****Click****Apply**.

**The values change based on the calculation. Wrangler adds the corresponding function as a step in the recipe. For example, if you Subtract 2 from each value in the Price column, Wrangler adds the following transformation to the recipe:**

**...**

**To apply a numeric calculation to two columns, follow these steps:**

**To select the columns, click the box to the right of the column names.****Click the drop-down button next to one of the column names and click****Calculate**.**Select the numeric function you want to perform.****You can choose to create a new column with the results of numeric calculations or overwrite the values in the current column.****Click****Apply**.

**The values change based on the calculation. Wrangler adds the corresponding function as a step in the recipe. For example, if you Add the values in each row of the Q1_Sales and Q2_Sales columns and create a new column called H1_Sales, Wrangler adds the following transformation to the recipe:**

**...**

**When you run the data pipeline, Wrangler performs the transformation and creates a new column called H1_Sales with the total of Q1_Sales and Q2_Sales.**

**Performing numeric calculations on values in three or more columns**

**Note:** Performing numeric calculations on values in three or more columns was added in CDAP 6.8.

**You can perform the following calculations on values in each row in three or more columns:**

**To apply a numeric calculation to three or more columns, follow these steps:**

**To select the columns, click the box to the right of the column name.****Click the drop-down button next to one of the column names and click****Calculate**.**Select the numeric function you want to perform.****You can choose to create a new column with the results of numeric calculations or overwrite the values in the current column.****Click****Apply**.

**The values change based on the calculation. Wrangler adds the corresponding function as a step in the recipe. For example, if you Add the values in each row of the Q1_Sales, Q2_Sales, Q3_Sales, and Q4_Sales columns and create a new column called 2022_Sales, Wrangler adds the following transformation to the recipe:**

`set-column :2022_Sales arithmetic:add(Q1_Sales, Q2_Sales, Q3_Sales, Q4_Sales)`

**When you run the data pipeline, Wrangler performs the transformation and creates a new column called 2022_Sales with the total of Q1_Sales, Q2_Sales, Q3_Sales, and Q4_Sales.**