Sum (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Queue, stack, list and array management functions

See also

Sum (Function)

In french: Somme

Calculates the sum of the array elements.

Versions 18 and later

This function is now available for iPhone/iPad applications.

New in version 18

This function is now available for iPhone/iPad applications.

Versions 19 and later

This function is now available for Windows Mobile applications.

New in version 19

This function is now available for Windows Mobile applications.

Versions 21 and later

This function is now available in Apple Watch mode.

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Apple Watch mode.

This function is now available in Universal Windows 10 App mode.

This function is now available in Apple Watch mode.

This function is now available in Universal Windows 10 App mode.

Versions 22 and later

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

New in version 22

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

Versions 25 and later

This function is now available in browser code.

New in version 25

This function is now available in browser code.

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>: Digital

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>: Digital

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 (with or without quotes)

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>: Digital

Sum of the column values.

<Array>: Array variable

Name of the two-dimensional numeric array.

<Column>: entier

Subscript 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).
the real type (on 4 or 8 bytes), the currency type and the numeric type.
the Duration type.

Sum of durations

If Sum is used to calculate a sum of durations, all the parameters must have the Duration type.

Business / UI classification : Neutral code

Component : wd260wm.dll