sum2

sum2(X)

X is a scalar/vector/matrix/table.

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.

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

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.

sum2(1 2 3);
// output
14

sum2(1 NULL NULL);
// output
1

sum2(1.5 4.6 7.8);
// output
84.25

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

sum2(m);
// output
[14,77]