Number Functions

Number Functions


Click here to download a complete list of formulas.

TrackVia has built-in number functions. The table below describes how these functions can be used in a calculated field's formula and the inputs that the functions require. In your formulas, these would be: 

  • Field name inside curly brackets
  • Text in quotes
  • Numbers on their own or within quotes

Function Description
abs()

abs(number)
Absolute value of a number

abs(-1) returns 1
abs(1) returns 1
exp()

exp(x)
Exponential of x (e to the power of x)

exp(1) returns 2.718...
ln()

ln(x)
Natural logarithm of x (base e)
ln(2) returns 0.693...
log()

log(base_or_x, x)
Logarithm of x (specified base)
log(3, 2) returns 1.584...
log10()

log10(x)
Common logarithm of x (base 10)
log10(2) returns 0.301...
mod()

mod(number, modulus)
Returns the remainder after dividing number by modulus
mod(7, 2) returns 1
mod(6, 2) returns 0
power()

power(x, y)
Raise x to the power of y
power(2, 3) returns 8
rand()

rand()
Returns a random number between 0 and 1

Please note that when a Calculated or Triggered Number field references another field that uses rand(), the results may be unpredictable.
round()

round(x, y)
Rounds a number, x, to y number of decimal places
round(4/3, 3) returns 1.333
round(1.6772, 2) returns 1.68
sign()

sign(x)
Returns 0 if x is zero, -1 if x is negative, and 1 if x is positive
sign(5) returns 1
sign(0) returns 0
sign(-5) returns -1
sqrt()

sqrt(x)
Square root of x
sqrt(64) returns 8
sqrt(12) returns 3.464...
sin()

sin(x)
Sine of x
sin(2) returns 0.909...
cos()

cos(x)
Cosine of x

cos(2) returns -0.416...
tan()

tan(x)
Tangent of x

tan(2) returns -2.185...
asin()

asin(number)
Inverse Sine of a number
asin(1) returns 1.570...
acos()

acos(number)
Inverse Cosine of a number
acos(1) returns 0
atan()

atan(number)
Inverse Tangent of a number
atan(1) returns 0.785...
atan2()

atan2(x, y)
Arc tangent of the two variables x and y
atan2(1, 2) returns 0.463...
degrees()

degrees(radians)
Number of degrees in an angle of x radians
degrees(π/2) returns 90
radians()

radians(degrees)
Number of radians in an angle of x degrees
radians(90) returns π/2 (1.570...)
pi()

pi()
The constant pi, 3.14159... (takes no inputs)
ceiling()

ceiling(x)
Rounds up to the next integer.

ceiling(6.1) returns 7.
floor()

floor(x)
Rounds down to the closest integer.

floor(6.1) returns 6.
null()

null()
The null() function can be used on its own or in a logic formula. This function is commonly used in an if() function to return nothing in a field if a condition is not met.
coalesce()

coalesce()
The coalesce() function serves to substitute null values with another value for arithmetic expressions.

Coalesce({Field1}, 0) + Coalesce({Field2}, 0) will add Field1 and Field2 together even if one value is null.

Feedback and Knowledge Base