Sum (Expression Function)


The Sum function (SUM) is used to sum all the numbers together from multiple field values.


The Sum function has one parameters:

Field Value

Allowed Inputs: field values

The parameter of the Sum function is the field values that contains the numbers that will be summed together. The input is a query built using the Query Builder to find field values on one or many record(s) in a table.


The output of the Sum function is a number representing a sum of all the values found.


If an Invoice record has 4 related Line Item records, and those records have values of -6, 0, 8, and 24 in the Quantity field, SUM(${Line Item ~> Quantity}) would result in 26 (since -6 + 0 + 8 + 24 = 26).

expression function - sum.txt · Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2023