Math and Trig Functions

Excel Function 1010data Function Description
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.