sum3

Syntax

sum3(X)

Arguments

X is a scalar/vector/matrix/table.

Details

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

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

If X is a table, calculate the sum of cubes 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.

Examples

sum3(1 2 3);
// output
36

sum3(1 NULL NULL);
// output
1

sum3(1.5 4.6 7.8);
// output
575.263

m=matrix(1 2 3, 4 5 6);
m;
#0 #1
1 4
2 5
3 6
sum3(m);
// output
[36,405]