Label Expression Functions

Note:

Functions can be either upper case or lower case but not mixed case. The editor buttons will always insert functions in upper case. Unless otherwise stated, theta is in radians.

ABS(x) Returns the absolute value of x.
ACOS(x) Returns the arccosine of x.
ASIN(x) Returns the arcsine of x.
ATAN(x) Returns the arctangent of x.
ATAN2(y,x) Returns the arctangent of y/x in the correct quadrant based on sines of x and y.
CEIL(x) Ceiling function: returns the smallest integer that is not less than x. For example, CEIL(1/3) is 1.
COS(theta) Returns the cosine of theta.
COSH(theta) Returns the hyperbolic cosine of theta.
COT(theta) Returns the cotangent of theta.
COTH(theta) Returns the hyperbolic cotangent of theta.
CSC(theta) Returns the cosecant of theta.
CSCH(theta) Returns the hyperbolic cosecant of theta.
DEG2GRD(theta) Converts theta in degrees to gradians.
DEG2RAD(theta) Converts theta in degrees to radians.
DRVSTN(x) Returns the derived station from a raw station x, using the station equations. This function is meaningful only for entities that support station equations (alignments, vertical alignments, sample lines, graph profiles, pipes and structures).
EXP(x) Returns the exponential of x.
FLOOR(x) Returns the largest integer that is less-than or equal to x. For example, FLOOR(3/2) is 1.
FMOD(x,y) Returns the floating point remainder of x/y.
GRD2DEG(theta) Converts theta in gradians to degrees.
GRD2RAD(theta) Converts theta in gradients to radians.
IF(test,true_val,false_val)

Evaluates test - if test is non-zero evaluates and returns true_val else evaluates and returns false_val. True_val and false_val can be any expression.

For example, where x is a Property:

IF(x=0,1,sin(x)/x)

The above tests x to see if it is zero, and if it is, the expression returns 1. If x is non-zero, the expression returns sin(x)/x.

LOG(x) Returns the log (base e) of x.
LOG10(x) Returns the log (base 10) of x.
MAX(a,b) Returns maximum value of a and b.
MIN(a,b) Returns minimum value of a and b.
POW(x,y) Returns x raised to the y power.
POW10(x) Returns x raised to 10.
RAD2DEG(theta) Converts theta in radians to degrees.
RAD2GRD(theta) Converts theta in radians to gradians.
ROUND(x) Rounds x to the nearest integer.
ROUNDDOWN(x,y) Rounds x down toward zero to y number of decimal places. For example, ROUNDDOWN(3.2,0) rounds down to zero decimal places. The result is 3. ROUNDDOWN(3.14159,3) rounds down to three decimal places. The result is 3.141.
ROUNDUP(x,y) Rounds x up away from zero to y number of decimal places. For example, ROUNDUP(3.2,0) rounds up to zero decimal places. The result is 4. ROUNDUP(3.14159,3) rounds up to 3 decimal places. The result is 3.142.
SIN(theta) Returns the sin of theta.
SEC(theta) Returns the secant of theta.
SECH(theta) Returns the hyperbolic secant of theta.
SINH(theta) Returns the hyperbolic sin of theta.
SQR(x) Returns x squared (x*x).
SQRT(x) Returns the square root of x.
TAN(theta) Returns the tangent of theta.
TANH(theta) Returns the hyperbolic tangent of theta.
TRUNC(x) Truncates x to an integer value.