# Can Tadabase calculate totals, averages and conditional values?

> Yes. Equation and formula fields calculate per record, Rollup fields total, average or count connected records, and default values fill fields by rule.

Source: https://tadabase.com/docs/faq/can-tadabase-calculate-values  
Status: Verified Nov 22, 2026. Checked against the current product

Yes. Equation and formula fields calculate a value for each record from its other fields, including `IF` logic for conditional values, and Rollup fields total, average, count or find the lowest or highest value across connected records, such as a student's average grade per grading period. The results are saved with each record, so you can sort, filter and show them like any other field.

## Which field to use

| To | Use |
| --- | --- |
| Calculate from fields of the same record, with functions and `IF` conditions | [Equation](https://tadabase.com/docs/data/equation) |
| Add, subtract, multiply or divide numbers | [Number Formula](https://tadabase.com/docs/data/number-formula) |
| Join fields and text into one value | [Text Formula](https://tadabase.com/docs/data/text-formula) |
| Count, sum, average, minimum or maximum of connected records, optionally only those that match conditions | [Rollup](https://tadabase.com/docs/data/rollup) |
| Time between two dates, or a date plus some time | [Date Formula](https://tadabase.com/docs/data/date-formula) |
| Fill a field with a value when a record is created or a form opens, fixed or based on conditions | [Default values](https://tadabase.com/docs/data/default-values) |

An Equation reads only its own table. To use connected records in one, add a Rollup first and use it in the equation. See [Fields you can use in equations and formulas](https://tadabase.com/docs/data/which-fields-are-referenceable-in-equations-and-formulas).
