# Calculate numbers with a Number Formula

> Add, subtract, multiply and divide number fields and fixed values, such as hours times rate, and choose decimals and a currency symbol for the result.

Source: https://tadabase.com/docs/data/number-formula  
Status: Verified Nov 17, 2026. Checked against the current product

A Number Formula field calculates a number from other number fields and fixed values with `+`, `-`, `*`, `/` and parentheses. Use it for simple arithmetic such as `Hours * Rate`. For IF logic, rounding functions or other functions, use an [Equation](https://tadabase.com/docs/data/equation) instead.

> **Note:** In the field type list this field is called **Number Formula**. Older help pages call it Basic Formula; it is the same field.

## Add a Number Formula field

In this example the Invoices table, which has **Hours** and **Rate** fields, gets a **Labor Total** field.

1. **Open the table** In the **Data Builder**, open the **Invoices** table and click the **Fields** tab.
2. **Choose the field type** Click **Add New Field**. Under **Equation**, click **Number Formula**, then click **Add and Configure**.
3. **Name it** Enter a **Name**, for example `Labor Total`.
4. **Add the first field** Next to **Formula**, click **Add Field** and pick **Hours**.
5. **Add an operator** Click the `*` button.
6. **Add the second field** Click **Add Field** again and pick **Rate**. The line under the formula now reads `Hours*Rate`.
7. **Set the format** Choose **Decimal Places** (for money, `2`) and, if you want a symbol, a **Currency Type** and **Format**.
8. **Save** Click **Save**. If the formula is not complete, for example it ends with an operator, the builder shows Invalid Formula and does not save it.

![A new Number Formula field showing the Add Field button, the operator buttons and the custom value box](https://tadabase.com/docs-shots/data-number-formula-builder.webp)

## Build the formula

| Part | How to add it |
| --- | --- |
| A field | Click **Add Field** and pick it. Type in **Find a field** to filter the list. |
| An operator | Click `+`, `-`, `*`, `/`, `(` or `)`. |
| A fixed number | Type it in **Enter custom value** and click **Add**. |

- Drag a part left or right to move it, and click its **x** to remove it.
- Multiplication and division happen before addition and subtraction. Use parentheses to change the order, for example `(Hours * Rate) + Trip Fee`.
- An empty field counts as `0`.

## Fields you can add

| From | Field types |
| --- | --- |
| This table | Number, Currency, Slider, Auto Increment, Equation fields whose output is a number, Date Formula fields, and older Count, Maximum, Minimum, Average and Sum fields |
| Connected tables | Number, Currency, Number Formula, and Equation fields whose output is a number |
| Both | Radio, Select, Checkbox and Multi-Select fields that store a number for each option (**Score Value**) |

A Date Formula field is listed four times, as **(in seconds)**, **(in minutes)**, **(in hours)** and **(in days)**. Pick the unit you want to calculate with, for example a job's duration in hours times an hourly rate.

> **Connected values come from one record:** A field from a connected table is read from one connected record. To add up the values of all connected records, use a [Rollup](https://tadabase.com/docs/data/rollup) with **Sum Value**.

## Reuse another Number Formula

A Number Formula cannot use another Number Formula field from the same table. Repeat that formula inside parentheses instead.

For example, if **Labor Total** is `Hours * Rate` and you want **Invoice Total** to add a fixed trip fee of 45, build **Invoice Total** as `( Hours * Rate ) + 45`: click `(`, add **Hours**, click `*`, add **Rate**, click `)`, click `+`, then type `45` in **Enter custom value** and click **Add**.

## Format the result

| Setting | Options | Default |
| --- | --- | --- |
| **Currency Type** | **No currency**, a currency from the list, or **Custom** (type your own symbol) | **No currency** |
| **Format** | Where the symbol goes: **None**, **Suffix** or **Prefix** | **Suffix** |
| **Decimal Places** | **None**, `0` to `5`, or `10` | `0` |
| **Thousands Delimiter** | **None**, **Comma**, **Period** or **Space** | **None** |
| **Disable Rounding** | On: the full value is kept for storage and other calculations, and the display is cut to **Decimal Places** instead of rounded | Off |
| **Enable** | Off: the field stops recalculating when records change; saved values stay as they are | On |

## When to use an Equation instead

- You need IF logic, rounding or other functions.
- You need another Number Formula, a Rollup or a Rating from the same table. An Equation can use them; a Number Formula cannot.
- You need text or dates in the result.

Keep the Number Formula when you need a value from a connected record: an [Equation](https://tadabase.com/docs/data/equation) only reads fields of its own table.
