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