Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
titleDescription

Calculates the sum of the values in the given column of the given dataset, or the sum for a series of numbers specified as arguments. When looking up the sum in a dataset, the column may be specified as an index or as a column name. Any null values in the column are ignored. If there are no rows in the dataset, zero is returned. 

Panel
titleSyntax

sum(dataset, columnIndex)

  • Parameters

DataSet dataset - The dataset to use.

int columnIndex - The index of the column to use. Must be a column index of the provided dataset.

  • Returns

int/float The sum of the values in that column.

...

Panel
titleExamples
For example, suppose you had a table with this dataset in it.
 


ProductCode

Quantity

Weight

BAN_002

380

3.243

BAN_010

120

9.928

APL_000

125

1.287

FWL_220

322

7.889

Code Block
languageactionscript3
titleCode Snippet
sum({Root Container.Table.data}, 1) //... would return 947
Code Block
languageactionscript3
titleCode Snippet
sum(1,2,3) //... would return 6