VDT: Supported functions and Example usage
Modified on: Mon, 26 Oct, 2020 at 9:59 AM
The following functions are supported by the system:
| Function | Description | Example Usage |
|---|
| abs | Returns the absolute value of a number | abs(a) |
| ceil | Returns the smallest integral value that is greater than or equal to the specified number | ceil(a) |
| floor | Returns the largest integer less than or equal to the specified number | floor(a) |
| round | Rounds a number to the nearest integral value | round(a) |
| trunc | Returns the integral part of a specified number | trunc(a) |
| exp | Returns e raised to the specified power | exp(a) |
| min | Returns the smaller of two numbers | min(a, b) |
| max | Returns the larger of two numbers | max(a, b) |
| avg | Returns the average of two numbers | avg(a, b) |
| pow | Returns a specified number raised to the specified power | pow(a, b) |
| sqrt | Returns the square root of a specified number | sqrt(a) |
| log | Returns the natural (base b) logarithm of a specified number | log(a,b) |
| log10 | Returns the base 10 logarithm of a specified number | log10(a) |
| sin | Returns the sine of the specified angle | sin(a) |
| cos | Returns the cosine of the specified angle | cos(a) |
| tan | Returns the tangent of the specified angle | tan(a) |
| asin | Returns the angle whose sine is the specified number | asin(a) |
| acos | Returns the angle whose cosine is the specified number | acos(a) |
| atan | Returns the angle whose tangent is the specified number | atan(a) |
| atan2 | Returns the angle whose tangent is the quotient of two specified numbers | atan2(a, b) |
| sinh | Returns the hyperbolic sine of the specified angle | sinh(a) |
| cosh | Returns the hyperbolic cosine of the specified angle | cosh(a) |
| tanh | Returns the hyperbolic tangent of the specified angle | tanh(a) |
| isnull | Returns a default value when the expected value is null | isnull(a, 0) |
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.
