# Custom formula column
## Overview
A **custom formula column** allows users a new column where each cell's value is dynamically calculated based on a formula. The formula can reference other columns, perform calculations, apply logical operations, or even use built-in functions.
#### Example:
If you have a dataset with columns "Price" and "Quantity", you could create a custom formula column called "Total Cost" that multiplies these two columns, with a formula like:
```mathematica
= {Price} * {Quantity}
```
## Open custom formula column pop-up
* For Table, you can create a Fx column by clicking on the icon next to the last column.
* For other widgets, you can find the Fx icon when adding the column to create a widget.
## Create a custom formula column
* You will be asked to fill in the Column name and the Formula
* Select the arrows next to Fields and Functions to browse and pick the desired column easily.
* You can input directly into the Formula field to display results close to the result.
* Click the Save column button to finish the setup.
* Click the Discard button to go back to the previous state.
{% hint style="info" %}
You can check at the bottom of the field to see if the Fx column is aggregated or analytic.
{% endhint %}
* The newly create Fx column will be on the right side of the Table.
* For other charts, you can select it on the list.
## Edit a custom formula column
* Click on the :pen\_fountain: icon of the Fx column.
* Click on the Formula text.
* You can click directly on Properties to edit it.
{% hint style="info" %}
This column is local to the View and won’t impact the data model
{% endhint %}
{% hint style="warning" %}
* In pivot, aggregated/analytical columns can only be used in Values.
* In the vertical bar, the aggregated/analytical column can only be used for the Y-axis.
{% endhint %}
## Delete a custom formula column
* Simply click the Delete button in the Edit column to delete the Fx column.
