The SUM function is one of the most widely used functions in SharpCloud, it has a wide range of applications and is used to simply add an array of numbers together.




x = Values that will be added together.

Data Type Returned

SUM will return a number.


SUM([2,3,4,1,6]) will return 16

Using the SUM function in conjunction with the RELATEDITEMS and GETITEMVALUES functions to discover the sum of all the “Costs” of related projects.

SUM(GETITEMVALUES(RELATEDITEMS(), ‘Cost’)) will return the sum of the cost of all related items.