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]