ABS(number) |
abs(X) |
Returns the absolute value of a given value. |
SQRT(number) |
sqrt(X) |
Returns the square root of the given value. |
POWER(number,power) |
exp(X;Y) |
Returns the first given value raised to the power of the second given
value. |
MROUND(number, multiple) |
round(X;Y) |
Returns the result of rounding the first given value to the nearest multiple of
the second given value. |
FLOOR(number,significance) |
floor(X) |
Returns the largest integer less than or equal to the given value, expressed as a
decimal number. |
CEILING(number,significance) |
ceil(X) |
Returns the smallest integer greater than or equal to the given value, expressed
as a decimal number. |
COS(number) |
cos(X) |
Returns the cosine of the given value. |
SIN(number) |
sin(X) |
Returns the sine of the given value. |
TAN(number) |
tan(X) |
Returns the tangent of the given value. |
SUM(number1,[number2],...) |
g_sum(G;S;X) |
For Excel, it returns the sum of the specified numbers. For 1010data, it returns
the sum of values within a given group. |
r_sum(C;S) |
For Excel, it returns the sum of the specified numbers. For 1010data, it returns
the sum of values across a given set of columns. |
<tabu label="Sum of Numbers"
breaks="columns"> <tcol source="column" fun="sum"/>
</tabu> |
For Excel, it returns the sum of the specified numbers. For 1010data,
<tabu> defines a tabulation or cross-tabulation
and<tcol> defines a result column in a tabulation. Defining
fun as sum, calculates the sum of the specified
column. |
PRODUCT(number1,[number2],...) |
g_prod(G;S;X) |
For Excel, it returns the product of the specified numbers. For 1010data, it
returns the product of values within a given group. |
r_prod(C;S) |
For Excel, it returns the product of the specified numbers. For 1010data, it
returns the product of values across a given set of columns. |
