Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
824
|
Functions available in the Functions Pane within the Calculated Field Editor are Numeric, Trigonometric or String.
Numeric functions are math functions most likely used on Measures. Trigonometric functions are for use with lengths and angles of triangles. String functions most commonly work with strings and text formatting of Dimensions.
ABS(X)
Returns the absolute value of a number, which will always be zero or a positive number
Example: ABS(-11.2)
will return 11.2
CEIL(X)
Returns the nearest integer value greater than or equal to x
Example: CEIL(10.2)
will return 11
CEILING(X)
Returns the nearest integer value greater than or equal to x
Example: CEILING(10.2)
will return 11
E(X)
Returns the base of natural logarithm 2.71828183
Example: E()
will return 2.71828183
EXP(X)
Returns the value of e (the base of natural logarithms - where e = 2.71828183) raised to the x power
Example: EXP(2)
will return 7.38905609893065
FLOOR(X)
Returns the nearest integer value less than or equal to x. If number is already rounded, it simply returns the number unchanged
Example: FLOOR(43.9)
will return 43
Example: FLOOR(-27.8)
will return -28
Example: FLOOR(27)
will return 27
LOG(X) or LOG(B,X)
With one argument, returns the natural logarithm (logarithm base e - 2.71828183) of x
With two arguments, returns the logarithm of x for the provided base b
Example: LOG(25)
will return 3.2188758248682006
Example: LOG(4, 25)
will return 2.321928094887362
with a base of 4
LOG10(X)
Returns the logarithm base 10 of x
Example: LOG10(25)
will return 1.3979400086720375
LOG2(X)
Returns the logarithm base 2 of x
Example: LOG2(25)
will return 4.643856189774724
MAX(X1,X2, ...)
Returns the maximum value among the provided arguments - at least 2 arguments
Example: MAX(2,5,1)
will return 5
MIN(X1,X2, ...)
Returns the minimum value among the provided arguments - at least 2 arguments
Example: MIN(2,5,1)
will return 1
MOD(N,M)
Returns n modulo m (the remainder of n divided by m)
Example: MOD(12, 5)
will return 2
PI()
Returns the constant π (= 3.1415926535...), the ratio between the circumference and diameter of a circle
Example: Will return 3.141592653589793
POW(X)
Returns a "negative safe" square root of x, equivalent to SIGN(x) * SQRT(ABS(x))
Example: POW(16)
will return 4
POWER(X, Y)
Return the value of x raised to the exponent y
Example: POWER(10, 3)
will return 1000
ROUND(X)
Returns the value of x rounded to the nearest integer
Example: ROUND(PI())
will return 3
SAFELOG10(X)
Returns a "negative safe" logarithm base 10 of x, equivalent to SIGN(x) * LOG10(ABS(x))
Example: SAFELOG10(25)
will return 1.3979400086720375
SAFESQRT(X)
Returns a "negative safe" square root of x
Example: SAFESQRT(16)
will return 4
SIGN(X)
Returns the sign of x: 1 for positive, -1 for negative
Example: SIGN(-55)
will return -1
Example: SIGN(55)
will return 1
SQRT(X)
Returns the square root of x
Example: SQRT(64)
will return 8
ACOS(X)
Returns the inverse cosine (arc cosine) 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
Example: ACOS(.5)
will return 1.0471975511965979
ASIN(X)
Returns the inverse sine (arc sine) of x. The valid range for the ASIN() input argument is from -1 through 1.
Example: ASIN(-1)
will return -1.5707963
ATAN(X)
Returns the inverse tangent (arc tangent) of x. Inputs are in an unbounded range, and the return value is given in radians, ranging from -pi/2 to pi/2
Example: ATAN(1)
will return .785398163
ATAN2(Y,X)
For the Cartesian coordinates x, y return the polar coordinate angle theta. 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. ATAN2(n1,n2) is the same as ATAN2(n1/n2)
Example: ATAN2(1, 0)
will return 1.5707963267948966
COS(X)
Returns the cosine of x(an angle expressed in radians)
Example: COS(38)
will return 0.9550736440472949
COT(X)
Returns the cotangent of x. Represents the cotangent function cos(x)/sin(x)
Example: COT(20)
will return 0.4469951089489167
DEGREES(X)
Converts x from radians to degrees
Example: DEGREES(PI())
will return 180
RADIANS(X)
Converts x from degrees to radians
Example: RADIANS(28.5)
will return 0.4974188368183839
SIN(X)
Returns the sine in radians of x
Example: SIN(2.3)
will return 0.7457052121767203
TAN(X)
Returns the tangent of x in radians
Example: TAN(.35)
will return 0.36502849483042454
CAP(str)
Capitalize words in the string str. Individual words/names will be given uppercase first letters, with all other letters in lowercase
Example: CAP("the house")
will return "The House"
CONCAT(str1, str2, ...)
Concatenate the input strings into one resulting string
Example: CONCAT("Here", "we", "go")
will return "Herewego"
CONCAT_WS(separator, str1, str2, ...)
Concatenate with separator. Concatenates the input strings into one resulting string, placing the string separator between each of the other arguments
Example: CONCAT_WS("-","Here", "we", "go")
will return "Here-we-go"
FORMAT(X,D)
Format the number x as a string of the type "#,###.##", showing d decimal places
Example: FORMAT(12332.123456, 4)
will return 12,332.1235
INSERT(str, pos, len, newstr)
Replaces the substring of length len starting at position pos in input string str with the string newstr
Example: INSERT("THIS", 1, 4, "THAT")
will return "THAT"
LCASE(str)
Returns the string str mapped to lowercase letters
Example: LOWER("California")
will return "california"
LEFT(str, len)
Returns the leftmost len characters of string str
Example: LEFT("Aquafold", 4)
will return "Aqua"
LENGTH(str)
Returns the length, in characters, of the input string str
Example: LENGTH("Sunnyvale")
will return 9
LOWER(str)
Returns the string str mapped to lowercase letters
Example: LOWER("California")
will return "california"
LPAD(str, len, padstr)
Pad the left side of string str with copies of string pad, up to a total padding of len characters
Example: LPAD("California", 15, "X" )
will return "XXXXXCalifornia"
MID(str, pos) or MID(str, pos, len)
For two arguments, returns the substring of str starting at position pos and continuing to the end of the string
For three arguments, returns the substring of str of length len, beginning at position pos
Example: MID("Have a happy day", 8)
will return "happy day"
Example: MID("Have a happy day", 8, 5)
will return "happy"
POSITION(substr, str)
Returns the starting position of the first occurrence of substring substr in the string str. Returns 0 if the substring is not found
Example: POSITION("great", "Have a great day")
will return 8
Example: POSITION("test", "Have a great day")
will return 0
REPEAT(str, count)
Returns a string consisting of str repeated count times
Example: REPEAT("California", 3)
will return "CaliforniaCaliforniaCalifornia"
REPLACE(str, from_str, to_str)
Returns a copy of str in which all occurrences of from_str have been replaced by to_str
Example: REPLACE("Have a happy day", "happy", "great")
will return "Have a great day"
REVERSE(str)
Returns a reversed copy of the input string str
Example: REVERSE("New York")
will return "kroY weN"
RIGHT(str, len)
Returns the len rightmost characters of string str
Example: RIGHT("Happy Day", 3)
will return "Day"
RPAD(str, len, padstr)
Pad the right side of string str with copies of string pad, up to a total padding of len characters
SPACE(N)
Returns a string consisting of n whitespace characters
Example: SPACE(12)
will return " "
SUBSTRING(str, pos) or SUBSTRING(str, pos, len)
For two arguments, returns the substring of str starting at position pos and continuing to the end of the string
For three arguments, returns the substring of str of length len, beginning at position pos
Example: SUBSTRING("Have a happy day", 8)
will return "happy day"
Example: SUBSTRING("Have a happy day", 8, 5)
will return "happy"
UCASE(str)
Returns the string str mapped to uppercase letters
Example: UCASE("Hawaii")
will return "HAWAII"
UPPER(str)
Returns the string str mapped to uppercase letters
Example: UPPER("Hawaii")
will return "HAWAII"
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017