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.

  • Verified Nov 17, 2026
  • Classic builder

On this page
  1. Add a Number Formula field
  2. Build the formula
  3. Fields you can add
  4. Reuse another Number Formula
  5. Format the result
  6. When to use an Equation instead

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 instead.

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

Build the formula #

PartHow to add it
A fieldClick Add Field and pick it. Type in Find a field to filter the list.
An operatorClick +, -, *, /, ( or ).
A fixed numberType 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 #

FromField types
This tableNumber, Currency, Slider, Auto Increment, Equation fields whose output is a number, Date Formula fields, and older Count, Maximum, Minimum, Average and Sum fields
Connected tablesNumber, Currency, Number Formula, and Equation fields whose output is a number
BothRadio, 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.

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 #

SettingOptionsDefault
Currency TypeNo currency, a currency from the list, or Custom (type your own symbol)No currency
FormatWhere the symbol goes: None, Suffix or PrefixSuffix
Decimal PlacesNone, 0 to 5, or 100
Thousands DelimiterNone, Comma, Period or SpaceNone
Disable RoundingOn: the full value is kept for storage and other calculations, and the display is cut to Decimal Places instead of roundedOff
EnableOff: the field stops recalculating when records change; saved values stay as they areOn

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 only reads fields of its own table.

Was this page helpful?

Something wrong or missing on this page? Tell us.