Expressions
You can use numeric variables, functions and values in regular math expressions:
x = 100 a = a + 14 * 5 / (1 + x) + ("0.3" as double)
Equations (returning boolean values):
b = a == 15
You can use boolean variables, functions and values in boolean logic expressions:
a = isBlank("") b = isBlank("not blank string") c = b && a || false
Is the same as:
c = isBlank("") && isBlank("not a blank string")
Boolean operators
| | the OR operator |
& | the AND operator |
^ | the XOR operator |
! | the NOT operator |
|| | the short-circuit OR operator |
&& | the short-circuit AND operator |
== | the EQUAL TO operator |
!= | the NOT EQUAL TO operator |
String can be concatenated together by a + operator:
a = "first part" + "second part" + "third part"
Math funtions
Function | Description |
---|---|
| Returns the absolute value of a double value. |
| Returns the absolute value of a float value. |
| Returns the absolute value of an int value. |
| Returns the absolute value of a long value. |
| Returns the arc cosine of a value; the returned angle is in the range 0.0 through pi. |
| Returns the arc sine of a value; the returned angle is in the range -pi/2 through pi/2. |
| Returns the arc tangent of a value; the returned angle is in the range -pi/2 through pi/2. |
| Returns the angle theta from the conversion of rectangular coordinates (x, y) to polar coordinates (r, theta). |
| Returns the cube root of a double value. |
| Returns the smallest (closest to negative infinity) double value that is greater than or equal to the argument and is equal to a mathematical integer. |
| Returns the first floating-point argument with the sign of the second floating-point argument. |
| Returns the first floating-point argument with the sign of the second floating-point argument. |
| Returns the trigonometric cosine of an angle. |
| Returns the hyperbolic cosine of a double value. |
| Returns Euler's number e raised to the power of a double value. |
| Returns ex -1. |
| Returns the largest (closest to positive infinity) double value that is less than or equal to the argument and is equal to a mathematical integer. |
| Returns the unbiased exponent used in the representation of a double. |
| Returns the unbiased exponent used in the representation of a float. |
| Returns sqrt(x2 +y2) without intermediate overflow or underflow. |
| Computes the remainder operation on two arguments as prescribed by the IEEE 754 standard. |
| Returns the natural logarithm (base e) of a double value. |
| Returns the base 10 logarithm of a double value. |
| Returns the natural logarithm of the sum of the argument and 1. |
| Returns the greater of two double values. |
| Returns the greater of two float values. |
| Returns the greater of two int values. |
| Returns the greater of two long values. |
| Returns the smaller of two double values. |
| Returns the smaller of two float values. |
| Returns the smaller of two int values. |
| Returns the smaller of two long values. |
| Returns the floating-point number adjacent to the first argument in the direction of the second argument. |
| Returns the floating-point number adjacent to the first argument in the direction of the second argument. |
| Returns the floating-point value adjacent to d in the direction of positive infinity. |
| Returns the floating-point value adjacent to f in the direction of positive infinity. |
| Returns the value of the first argument raised to the power of the second argument. |
| Returns a double value with a positive sign, greater than or equal to 0.0 and less than 1.0. |
| Returns the double value that is closest in value to the argument and is equal to a mathematical integer. |
| Returns the closest long to the argument. |
| Returns the closest int to the argument. |
| Return d × 2scaleFactor rounded as if performed by a single correctly rounded floating-point multiply to a member of the double value set. |
| Return f × 2scaleFactor rounded as if performed by a single correctly rounded floating-point multiply to a member of the float value set |
| Returns the signum function of the argument; zero if the argument is zero, 1.0 if the argument is greater than zero, -1.0 if the argument is less than zero. |
| Returns the signum function of the argument; zero if the argument is zero, 1.0f if the argument is greater than zero, -1.0f if the argument is less than zero. |
| Returns the trigonometric sine of an angle. |
| Returns the hyperbolic sine of a double value. |
| Returns the correctly rounded positive square root of a double value. |
| Returns the trigonometric tangent of an angle. |
| Returns the hyperbolic tangent of a double value. |
| Converts an angle measured in radians to an approximately equivalent angle measured in degrees. |
| Converts an angle measured in degrees to an approximately equivalent angle measured in radians. |
| Returns the size of an ulp of the argument. |
| Returns the size of an ulp of the argument. |
| Returns the factorial of passed value. |
Samples
Simple computation
return (((value() as double) / 3600000) * 60)
Rounding
number = replace(value(), ',', '.') as double return round(number)
Notice we must normalize input to be valid number by normalizing the decimal separator.