## 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 1Please 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.