Number Functions

Question 1

ABS(number)

Answer 1

Returns the absolute value of the given number.
Example: ABS(-7) = 7
ABS([Budget Variance]) returns absolute of all values of this field.

Question 2

ACOS

Answer 2

Returns the arc cosine of the given number. The result is in radians.

ACOS(-1) = 3.14159265358979

Question 3

ASIN

Answer 3

Returns the arc sine of a given number. The result is in radians.

ASIN(1) = 1.5707963267949

Question 4

ATAN

Answer 4

Returns the arc tangent of a given number. The result is in radians

ATAN(180) = 1.5652408283942

Question 5

ATAN2

Answer 5

Returns the arc tangent of two given numbers (x and y). The result is in radians.

Example:

ATAN2(2, 1) = 1.10714871779409

Question 6

CEILING

Answer 6

Rounds a number to the nearest integer of equal or greater value.

Question 7

COS

Answer 7

Returns the cosine of an angle. Specify the angle in radians.

COS(PI( ) /4) = 0.707106781186548

Question 8

COT

Answer 8

Returns the cotangent of an angle. Specify the angle in radians.

COT(PI( ) /4) = 1

Question 9

DEGREES

Answer 9

Converts a given number in radians to degrees.

Example:

DEGREES(PI( )/4) = 45.0

Question 10

DIV

Answer 10

Returns the integer part of a division operation, in which integer1 is divided by integer2.

Example:

DIV(11,2) = 5

Question 11

EXP

Answer 11

Returns e raised to the power of the given number.

Examples:

EXP(2) = 7.389
EXP(-[Growth Rate]*[Time])

Question 12

FLOOR

Answer 12

Rounds a number to the nearest integer of equal or lesser value.

Example:

FLOOR(3.1415) = 3

Question 13

HEXBINX

Answer 13

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])

Question 14

HEXBINY

Answer 14

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])

Question 15

LN

Answer 15

Returns the natural logarithm of a number. Returns Null if number is less than or equal to 0.

Question 16

LOG

Answer 16

Returns the logarithm of a number for the given base. If the base value is omitted, base 10 is used.

LOG(number [, base])

Question 17

MAX

Answer 17

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])

Question 18

MIN

Answer 18

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])

Question 19

PI

Answer 19

Returns the numeric constant pi: 3.14159.

Question 20

POWER

Answer 20

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

Question 21

RADIANS

Answer 21

Converts the given number from degrees to radians.

Example:

RADIANS(180) = 3.14159

Question 22

ROUND

Answer 22

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])

Question 23

SIGN

Answer 23

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

Question 24

SIN

Answer 24

Returns the sine of an angle. Specify the angle in radians.

Examples:

SIN(0) = 1.0
SIN(PI( )/4) = 0.707106781186548

Question 25

SQRT

Answer 25

Returns the square root of a number.

Example:

SQRT(25) = 5

Question 26

SQUARE

Answer 26

Returns the square of a number.

Example:

SQUARE(5) = 25

Question 27

TAN

Answer 27

Returns the tangent of an angle. Specify the angle in radians..

Example:

TAN(PI ( )/4) = 1.0

Question 28

ZN

Answer 28

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]