SharpCloud: Function SUM()

Adds an array of numbers to return a total; widely used for calculations and roll-ups, often with RELATEDITEMS and GETITEMVALUES.

Title

Answer

Function SUM()

Description
Adds together an array of numbers; commonly used for totals and roll-up calculations.

Syntax

SUM(values)

Parameters

Return Value
NUMBER

Examples

Formula

SUM([2,3,4,1,6])

Result
16

Formula

SUM(GETITEMVALUES(RELATEDITEMS(), "Cost"))

Result
Sum of costs for all related items

Notes

URL Name

SharpCloud-Function-SUM

Related Articles