SUM() : add up several columns

In a formula-type column, the SUM function adds the contents of multiple columns or numeric values together. It returns a number.

Calling function parameters in TimeTonic:

$field_name = field (link, linked table column, number, selection, formula, text...).
"free text" = free text to add within quotes.
do not use quotes for numbers.

Syntax

SUM(column_1, column_2, ...)

Parameters

# Parameter Description

1 column_1, column_2, ... Number-type columns and/or numeric values to add together.

The output format of the result (number, currency, percentage...) is configured in the output field options of the formula editor. See Output format options in the Formula Column article.

Examples

Add two columns

I added the Amount excl. tax column with the VAT column.

SUM($Amount excl. tax, $VAT)

Result of SUM on the Amount excl. tax and VAT columns

Add a fixed amount

In addition to the previous example, I added 12.90 which could correspond, for example, to fixed fees.

SUM($Amount excl. tax, $VAT, 12.90)

Subtract via a negative number

Following the same logic, you can subtract an amount by adding a negative number:

SUM($Amount excl. tax, $VAT, -10)

Go further

SUM_ELEMENTS

To add up the values of a column in a linked table (multiple items).

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.