sum2

Syntax

sum2(X)

Arguments

X is a scalar/vector/matrix.

Details

If X is a vector, return the sum of squares of all the elements in X.

If X is a matrix, calculate the sum of squares for each column of X and return a vector.

As with all aggregate functions, NULL values are not included in the calculation.

If all elements of a calculation are NULLs, the result is NULL.

Please note that the data type of the result is always DOUBLE, even if the data type of X is INT or LONG.

Examples

$ sum2(1 2 3);
14

$ sum2(1 NULL NULL);
1

$ sum2(1.5 4.6 7.8);
84.25

$ m=matrix(1 2 3, 4 5 6);
$ m;

$ sum2(m);
[14,77]