Math Functions

Math functions are available from the Math Function menu. They include standard trigonometric operations, as well as functions for absolute value, exponents, and others. These functions are available for every data provider except for raster, WFS, and WMS providers.

The functions that return angles (for example, ARCCOS) are helpful in formulating expressions that define rotation.

When you create an expression for geospatial features, you can use the following math functions.

Function Definition Syntax Example

ABS

Returns the absolute value of a number (without its sign) using the input data type.

For example, ABS(-2)=2

ABS(Numeric_Property)

ABS(Pipe_Angle)

ACOS

Returns the arccosine, or inverse cosine, of a number between or equal to -1 and 1. (Arccosine is the angle that has a cosine equal to a given number.) The returned value is in radians with a Double data type.

For example, ACOS(.5)=pi/3

ACOS(Numeric_Property)

ACOS(Pipe_Property)

ASIN

Returns the arcsine, or inverse sine, of a number between or equal to -1 and 1. (Asin is the angle that has a sine equal to a given number.) The returned value is in radians with a Double data type.

For example, ASIN(.5)=pi/6

ASIN(Numeric_Property)

ASIN(Pipe_Property)

ATAN

Returns the arctangent, or inverse tangent, of any number. (Atan is the angle that has a tangent equal to a given number.) The returned value is in radians with a Double data type.

For example, ATAN(1)=pi/4

ATAN(Numeric Property)

ATAN(Pipe_Property)

ATAN2

Returns the arctangent, or inverse tangent, of X and Y coordinates of a point. Each coordinate can be any real number. The returned value is in radians with a Double data type.

For example, ATAN2(-.7071,.7071)=3pi/4

ATAN2(x_Numeric_Property, y_Numeric_Property)

ATAN2(NS_Street_Property, EW_Street_Property)

COS

Returns the cosine of an angle. The returned value has a Double data type. (In a right triangle, the cosine of an angle is the ratio of the adjacent side to the hypotenuse.)

For example, COS(pi/3)=.5

COS(Angle_Property)

COS(Pipe_Angle)

EXP

EXP returns e raised to the specified power, where e = 2.71828183 ...

EXP returns a value with a Double data type.

For example, EXP(2)=7.389056099...

EXP(Numeric_Property)

EXP(Street_Length_Property)

LN

Returns the natural logarithm of a positive number. The returned value has a Double data type. The natural log is often used to determine how long it will take to achieve a stated level.

For example, LN(2.71828183)=1

LN(Numeric Property)

LN(Desired_Level_Property)

LOG

Returns the logarithm, to the base specified, of a number. The returned value has a Double data type. The base can be any positive value other than 1 and the number can be any positive value.

For example, LOG(10,100)=2

LOG(Base, Numeric_Property)

LOG(10,Cost_Property)

MOD

Returns the remainder of a number (the dividend) after being divided by another number (the divisor).

For example, MOD(11,4)=3

Uses the FLOOR function to round. For more information, see Using Mod and Remainder.

MOD(Dividend, Divisor)

MOD(Parcel_Value, Parcel_Area)

POWER

Returns the result of one number raised to the power of a second number. The returned value has a Double data type.

The base and the exponent can be any numbers, but if the base is negative, then the power must be an integer.

For example, POWER(5,2)=25

POWER(Base_number,Power_number)

POWER(Parcel_Cost,2)

REMAINDER

Returns the remainder of a number after being divided by another number.

For example, REMAINDER(11,4)=-1

Uses the ROUND function to round. For more information, see Using Mod and Remainder

REMAINDER(Dividend, Divisor)

REMAINDER(Parcel_Cost,4)

SIN

Returns the sine of an angle. The returned value has a Double data type. In a right triangle, the sine of an angle is the ratio of the opposite side to the hypotenuse.

For example, SIN(pi/6)=.5

SIN(Angle_Property)

SIN(Pipe_Angle)

SQRT

Returns the square root of a positive number. The returned value has a Double data type.

For example, SQRT(25)=5

SQRT(Numeric_Property)

SQRT(Parcel_Area)

TAN

Returns the tangent of an angle. The returned value has a Double data type. In a right triangle, TAN is the ratio of the opposite side to the adjacent side.

For example, TAN(pi/4)=1

TAN(Angle_Property)

TAN(Pipe_Angle)