|
|
|
|
|
|
|
|
- Supported types
- Sum of durations
<Array>.Sum (Function) In french: <Tableau>.Somme Calculates the sum of the array elements. // Sum of elements found in an array of integers
MyArray is array of int = [1,2,3]
MySum is numeric
MySum = MyArray.Sum() // MySum = 6
Syntax
Calculating the sum of the elements found in a one-dimensional array (numeric types) Hide the details
<Result> = <Array>.Sum()
<Result>: Numeric Sum of the numeric elements found in the array. <Array>: Array variable Name of the one-dimensional array of numeric types containing the elements whose sum must be calculated.
Calculating the sum of the elements found in a one-dimensional array (structured types) Hide the details
<Result> = <Array>.Sum(<Member>)
<Result>: Numeric Sum of the values of members. <Array>: Array variable Name of the one-dimensional array of structured types. The following structured types are allowed: class, dynamic class, structure, dynamic structure.Remark: In an array of dynamic classes or in an array of dynamic structures, the element is ignored if it is not allocated. <Member>: Character string Name of the member containing the values that must be used to calculate the sum.
Calculating the sum of the elements found in a column of a two-dimensional array Hide the details
<Result> = <Array>.Sum(<Column>)
<Result>: Numeric Sum of the column values. <Array>: Array variable Name of the two-dimensional numeric array. <Column>: Integer Index of the array column containing the values that must be used to calculate the sum. Remarks Supported types The following types are supported for the arrays of numeric values and for the members of arrays of structured types: - all integer types (on 1, 2, 4 or 8 bytes, signed or unsigned + system integer).
- real (4 or 8-byte), currency and numeric types.
- the Duration type.
Sum of durations If <Array>.Sum is used to calculate a sum of durations, all parameters must be of type Duration. Sequence of functionsYou can use array functions in a sequence. The following functions can be used in a sequence: This sequence can be used as a source for a FOR ALL statement or it can end with one of the following functions: Example: gnMoyenne = gtabUser.Filtre(cbFiltre).Transforme(cbTransforme).Moyenne() Business / UI classification: Neutral code
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|