---
title: "Formulas and rollups that fill themselves in | SalexHub"
description: "A formula works out a value from the rest of a record; a rollup counts, totals or averages the records linked to it. No spreadsheet beside the system."
url: "https://salexhub.com/platform/data-model/formulas"
---

# Numbers that work themselves out.

A formula works out a value from the rest of a record. A rollup counts or adds up the records linked to it. Nobody keeps a spreadsheet beside the system to get them.

[Start free](https://app.salexhub.com/register) · [Relationships](https://salexhub.com/platform/data-model/relationships.md)

## Formulas

Days until a visit, a margin as a percent, a yes when a job runs late.

- A result as a number, a percent, an amount, a yes or no, a text or a date.
- 24 functions, for conditions, text, rounding and dates.
- A calculation and nothing more: it reads only its own record, so it cannot reach or change anything else.

## Rollups

The visits of a customer, the parts across them, the date of the last one.

- Count, Sum, Lowest, Highest or Average over the records linked to this one.
- Money never totals across currencies.

Both show in the table and on the record, beside the values people type in.

[Relationships](https://salexhub.com/platform/data-model/relationships.md) · [Properties](https://salexhub.com/platform/data-model/properties.md)

---

The same page for people: https://salexhub.com/platform/data-model/formulas. Index of this site for agents: https://salexhub.com/llms.txt