> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-formula-column.md).

# Add Formula Column

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 (database column).

Common use cases for formula columns include calculating profit margins, tracking performance metrics, creating planning and forecasting calculations, generating status indicators, and building custom KPIs from existing data.

1. To insert formula columns, select **PowerTable** > **Insert Column** > **Formula Column**.

<figure><img src="/files/KdHa7BsS4We2BonCRZnm" alt=""><figcaption></figcaption></figure>

2. Enter the column name.
3. Enter the required formula in the formula box. Formula suggestions appear automatically as you type. To view available functions and references, press **Ctrl** + **Space**.

<figure><img src="/files/YjY1OzXeEzQSja4CKFHm" alt="" width="563"><figcaption></figcaption></figure>

4. You can specify the currency type and the number of decimal points to display.

<figure><img src="/files/X8f61BP9cUJa8FmlgLVS" alt="" width="503"><figcaption></figcaption></figure>

5. If you want to add the formula column directly to the database, select **Create a database column**. Then, choose the appropriate data type and other settings, such as length, precision, scale, and so on.

{% hint style="info" %}

#### Note

Please ensure you have the required permissions to the database you are connected to, as you are adding a column directly to the source database.
{% endhint %}

<figure><img src="/files/Vbovfr5Yeg8pUESgr0AJ" alt="" width="563"><figcaption></figcaption></figure>

6. Select **Save**.&#x20;

The formula column is added to the table.

<figure><img src="/files/Jq0dJobq14qwxgAORL93" alt=""><figcaption></figcaption></figure>

### Related content

For more information about formulas and functions, you can refer to [Formula Syntax](/documentation/readme/planning-sheets/formula-syntax.md).


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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/documentation/readme/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.