Sum

Kalipso - Form - Expressions - Functions - Functions Descriptions - Numeric Functions - Sum

This Function returns a <numeric>, which is the the result of the sum of all the values of the specified Column of a Table.

Function available for the following operating systems:

Parameters

• Table <control> - Source Table control.

• Column <numeric> - Index of the column of the Table to sum the values from.

Examples

• Example 1

Assuming that Table "Products" has a Column called "Stock" with index "3", with 3 records. Lets assume that the values for each record on that column are respectively: 200, 150 and 45. Sum(CTRL(Products), 3) Result = 395

• Example 2

Assuming that Table "Products" has a Column called "Stock" with index "3", with 3 records. Lets assume that the values for each record on that column are respectively: "200", "150" and "EMPTY". Sum(CTRL(Products), 3) Result = 350

Regardless of the type pf the value in Column, it's always treated as a numeric. Therefore, if you try to execute this function over a Column filled with strings, each value will be converted to numeric before being added up to the result.