ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / Queue, stack, list and array functions / Array functions
  • Supported types
  • Sum of durations
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Calculates the sum of the array elements.
Example
// Sum of elements found in an array of integers
MyArray is array of int = [1,2,3]
MySum is numeric
MySum = Sum(MyArray) // MySum = 6
Syntax

Calculating the sum of the elements found in a a one-dimensional array (numeric types) Hide the details

<Result> = Sum(<Array>)
<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> = Sum(<Array> , <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> = Sum(<Array> , <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 Sum is used to calculate a sum of durations, all parameters must be of type Duration.


Sequence of functions
You 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:
gnMean = garrUser.Filter(cbFilter).Map(cbMap).Mean()
Business / UI classification: Neutral code
Component: wd290wm.dll
Minimum version required
  • Version 17
This page is also available for…
Comments
Exemplo sum
tabListanumeros is array of 0 int
//Adiciona Linha Array
ArrayAddLine(tabListanumeros,10)
ArrayAddLine(tabListanumeros,5)
ArrayAddLine(tabListanumeros,1)
//Mostra resultado Array
EDT_Texto = ArrayToString(tabListanumeros)

//http://doc.windev.com/en-US/?1000019892&name=Sum
//Calculates the sum of the array elements.
//Calcula a soma dos elementos da array.

EDT_Resultado=Sum(tabListanumeros)

http://windevdesenvolvimento.blogspot.com.br/2016/12/aula-1001-windev-array-010-sum.html
https://www.youtube.com/watch?v=8ABHvBiR6D4
De matos
20 Dec. 2016

Last update: 07/05/2022

Send a report | Local help