|
Function |
Description |
Example & Output |
|
Abs() |
Returns absolute value of the specified numeric expression |
abs(-17) 17 |
|
Int() |
Returns integer value |
int(17.15) 17 |
|
Floor() |
Returns nearest integer value that is less than or equal to the given number |
Floor(17.85) 17 |
|
Ceil() |
Returns nearest integer value that is higher than or equal to the given number |
Floor(17.85) 18 |
|
Mod() |
Returns remainder value |
Mod(45,6) 3 |
|
Round() |
Returns a numeric value rounded to a specified number of decimal |
Round(17.85) => 18 Round(17.15) => 17 |
|
Min() |
Returns lowest value from the list of values given (based on ASCII value – applicable to numbers, characters, date expressions) |
Min(10,17,18,5) => 5 |
|
Max() |
Returns highest value from the list of values given (based on ASCII value – applicable to numbers, characters, date expressions) |
Min(10,17,18,5) => 18 |
|
Sqrt() |
Returns square root of the given expression |
Sqrt(144) => 12 |
|
Log() |
Returns logarithmic value of the given expression. |
Log(10) => 2.30259 |
|
Log10() |
Returns logarithmic base 10 value of the given expression. |
Log10(10) => 1.0000 |
|
Acos() |
Returns cosine value of the given expression Similarly, asin(), atan() can also be used. |
Acos(0.5) = > 1.0472 |