![]() Returns the cosine of x(an angle expressed in radians)Įxample: COS(38) will return 0.9550736440472949 The argument x can be in an unbounded range and returns a value in the range of -pi to pi, depending on the signs of x and y, expressed in radians. Inputs are in an unbounded range, and the return value is given in radians, ranging from -pi/2 to pi/2įor the Cartesian coordinates x, y return the polar coordinate angle theta. Returns the inverse tangent (arc tangent) of x. The valid range for the ASIN() input argument is from -1 through 1. Returns the inverse sine (arc sine) of x. The argument x must be in the range of -1 to 1, and the function returns a value in the range of 0 to pi, expressed in radiansĮxample: ACOS(.5) will return 1.0471975511965979 ![]() Returns the inverse cosine (arc cosine) of x. Returns the sign of x: 1 for positive, -1 for negative Returns a "negative safe" square root of x, equivalent to SIGN(x)*SQRT(ABS(x)) Returns a "negative safe" logarithm base 10 of x, equivalent to SIGN(x) * LOG10(ABS(x))Įxample: SAFELOG10(25) will return 1.3979400086720375 Otherwise rounds to the nearest decimal precision Returns the value of x rounded to the nearest integer if precision is not used. Return the value of x raised to the exponent y Returns a "negative safe" square root of x, equivalent to SIGN(x) * SQRT(ABS(x)) Returns the constant π (= 3.1415926535.), the ratio between the circumference and diameter of a circle Returns n modulo m (the remainder of n divided by m) ![]() Returns the minimum value among the provided arguments - at least 2 arguments Returns the maximum value among the provided arguments - at least 2 arguments With one argument, returns the natural logarithm (logarithm base e - 2.71828183) of x If number is already rounded, it simply returns the number unchanged Returns the nearest integer value less than or equal to x. Returns the value of e (the base of natural logarithms - where e = 2.71828183) raised to the x powerĮxample: EXP(2) will return 7.38905609893065 Returns the base of natural logarithm 2.71828183 Returns the nearest integer value greater than or equal to x Returns the absolute value of a number, which will always be zero or a positive number Returns the population variance of the expression. Returns the sample variance of the expression. SUM can be used with numeric fields only. Returns the sum of all the values in the expression. Returns the population standard deviation of the expression. Returns the sample standard deviation of the expression. ![]() AVG can be used with numeric fields only. Returns the average of all the values in the expression. Aggregation functions are for dealing with aggregated values, Type Conversions Functions are for converting data types. Logical Functions are useful for if conditions. Table Calculation Functions are useful when working with Table Calculations. String functions most commonly work with strings and text formatting of Dimensions. Trigonometric functions are for use with lengths and angles of triangles. Number functions are math functions most likely used on Measures. Functions available in the Functions Pane within the Calculated Field Editor are Numeric, Trigonometric or String.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |