# Add Formula Column

PowerTable has a built-in formula engine that can perform calculations on your data. Formula columns are calculated columns created from your data that enable you to derive business-specific metrics or calculations on the go. You can add them at the visual level or directly to your source database.

{% stepper %}
{% step %}

### To insert formula columns, go to **Setup > Columns.**

![](/files/dc60216c0cf8044c32006e09fb0d4d3086da8330)

*Setup > Columns*
{% endstep %}

{% step %}

### Select **Add Visual Column > Add Formula Column.**

![](/files/80369c7a114cfa7d4a956fa78e95470644d43fa8)

*Add Formula Column*

You can also insert a formula column as shown below:

![](/files/aa6c67127dfdd8c014b3e878e67bfe42eb746e5c)
{% endstep %}

{% step %}

### Configure the formula column by entering the column name and required formula, then click **Save**.

![](/files/bcf654c85217ac348cb9466c13ffb8ac8f8567e7)

*Configuring a formula column*

* You can create a formula column directly in the database by selecting the checkbox labeled "**Create a database column**."
* Select the appropriate data type for the column. The formula column will be added to the source database.

![](/files/1ea5abb683d4f2dda5e3d75d35acf19df860735a)

*Creating a formula column in the database*

The formula column has now been added successfully.

![](/files/686001f9362d86a8bc0ce8dc921bb4068725a308)

*Formula column added*

Formula columns cannot be edited directly because their values are based on an underlying formula.

For more information about formulas and functions, you can refer to [this section.](https://docs.powertable.com/explore-powertable/formulas-and-functions)
{% endstep %}
{% endstepper %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/powertable-sheets/how-tos/adding-columns-overview/add-formula-column.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.