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 returnnothingin 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. |
Comments
0 comments
Article is closed for comments.