Number Functions Flashcards
ABS(number)
Returns the absolute value of the given number.
Example: ABS(-7) = 7
ABS([Budget Variance]) returns absolute of all values of this field.
ACOS
Returns the arc cosine of the given number. The result is in radians.
ACOS(-1) = 3.14159265358979
ASIN
Returns the arc sine of a given number. The result is in radians.
ASIN(1) = 1.5707963267949
ATAN
Returns the arc tangent of a given number. The result is in radians
ATAN(180) = 1.5652408283942
ATAN2
Returns the arc tangent of two given numbers (x and y). The result is in radians.
Example:
ATAN2(2, 1) = 1.10714871779409
CEILING
Rounds a number to the nearest integer of equal or greater value.
COS
Returns the cosine of an angle. Specify the angle in radians.
COS(PI( ) /4) = 0.707106781186548
COT
Returns the cotangent of an angle. Specify the angle in radians.
COT(PI( ) /4) = 1
DEGREES
Converts a given number in radians to degrees.
Example:
DEGREES(PI( )/4) = 45.0
DIV
Returns the integer part of a division operation, in which integer1 is divided by integer2.
Example:
DIV(11,2) = 5
EXP
Returns e raised to the power of the given number.
Examples:
EXP(2) = 7.389
EXP(-[Growth Rate]*[Time])
FLOOR
Rounds a number to the nearest integer of equal or lesser value.
Example:
FLOOR(3.1415) = 3
HEXBINX
Maps an x, y coordinate to the x-coordinate of the nearest hexagonal bin. The bins have side length 1, so the inputs may need to be scaled appropriately.
HEXBINX and HEXBINY are binning and plotting functions for hexagonal bins. Hexagonal bins are an efficient and elegant option for visualizing data in an x/y plane such as a map. Because the bins are hexagonal, each bin closely approximates a circle and minimizes variation in the distance from the data point to the center of the bin. This makes the clustering both more accurate and informative.
Example:
HEXBINX([Longitude], [Latitude])
HEXBINY
Maps an x, y coordinate to the y-coordinate of the nearest hexagonal bin. The bins have side length 1, so the inputs may need to be scaled appropriately.
Example:
HEXBINY([Longitude], [Latitude])
LN
Returns the natural logarithm of a number. Returns Null if number is less than or equal to 0.
LOG
Returns the logarithm of a number for the given base. If the base value is omitted, base 10 is used.
LOG(number [, base])
MAX
Returns the maximum of the two arguments, which must be of the same type. Returns Null if either argument is Null. MAX can also be applied to a single field in an aggregate calculation.
Examples:
MAX(4,7)
MAX(Sales,Profit)
MAX([First Name],[Last Name])
MIN
Returns the minimum of the two arguments, which must be of the same type. Returns Null if either argument is Null. MIN can also be applied to a single field in an aggregate calculation.
Examples:
MIN(4,7)
MIN(Sales,Profit)
MIN([First Name],[Last Name])
PI
Returns the numeric constant pi: 3.14159.
POWER
Raises the number to the specified power.
Examples:
POWER(5,2) = 52 = 25
POWER(Temperature, 2)
You can also use the ^ symbol:
5^2 = POWER(5,2) = 25
RADIANS
Converts the given number from degrees to radians.
Example:
RADIANS(180) = 3.14159
ROUND
Rounds numbers to a specified number of digits. The decimals argument specifies how many decimal points of precision to include in the final result. If decimals is omitted, number is rounded to the nearest integer.
ROUND(number, [decimals])
SIGN
Returns the sign of a number: The possible return values are -1 if the number is negative, 0 if the number is zero, or 1 if the number is positive.
Example:
If the average of the profit field is negative, then
SIGN(AVG(Profit)) = -1
SIN
Returns the sine of an angle. Specify the angle in radians.
Examples:
SIN(0) = 1.0
SIN(PI( )/4) = 0.707106781186548
SQRT
Returns the square root of a number.
Example:
SQRT(25) = 5
SQUARE
Returns the square of a number.
Example:
SQUARE(5) = 25
TAN
Returns the tangent of an angle. Specify the angle in radians..
Example:
TAN(PI ( )/4) = 1.0
ZN
Returns the expression if it is not null, otherwise returns zero. Use this function to use zero values instead of null values.
Example:
ZN([Profit]) = [Profit]