# Excel Numerical Functions (MDX)

A set of Excel like functions supported by icCube (if a parameter is null they will return null)

void

### Description

A list of Excel Numerical functions to follow MDX standard.

• ABS , returns the absolute value of the numerical parameter
• ACOS , returns the arc cosine
• ACOSH , returns the inverse hyperbolic cosine
• ASIN , returns the arc sine
• ASINH , returns the inverse hyperbolic sine
• ATAN , returns the arc tangent
• ATANH , returns the inverse hyperbolic tangent
• COS , returns the cosine
• COSH , returns the hyperbolic cosine
• DEGREES , returns the measurement of the angle parameter in degrees
• DOLLAR , returns the parameter
• EXP , returns the exponential (natural base)
• FACT , returns the factorial (n * (n-1) * (n-2) * ... * 1 , if n = 0 returns 1)
• INT , returns rounding defined as Math.round(d - 0.5)
• LN , returns the natural logarithm
• LOG10 , returns the logarithm with base 10
• RADIANS , returns the angle parameter in radians.
• SIGN , returns the sign of the parameter value (0,1,-1)
• SIN , returns the sine
• SINH , returns the hyperbolic sine
• SQRT , returns the positive square root
• TAN , returns the tangent
• TANH , returns the hyperbolic tangent
• ATAN2 , returns the java equivalent of Math.atan2
• CEILING(d0,d1) , returns the java equivalent of MathX.ceiling(d0, d1)
• COMBIN(d0,d1) , returns the java equivalent of MathX.nChooseK(d0,d1)
• FLOOR(d0,d1) , returns the java equivalent of MathX.floor(d0, d1)
• MOD(d0,d1) , returns the remainder resulting from operation: d0 / d1
• POWER(d0,d1) , returns the value of the first argument raised to the power of the second argument.
• ROUND(d0,d1) , returns the java equivalent of MathX.round(d0, (int) d1)
• ROUNDDOWN(d0,d1) , returns the java equivalent of MathX.roundDown(d0, (int) d1)
• ROUNDUP(d0,d1) , returns the java equivalent of MathX.roundUp(d0, (int) d1)
• LOG , returns the logarithm of base 10

### XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.