Numeric functions
This page goes over the numeric functions in Upsolver.
ABS
ABS
Returns the absolute value of a number.
input
result
5
5
-3
3
0
0
ADD
ADD
Adds two numbers together.
operand 1
operand 2
result
5.1
2.5
7.6
5
2
7
5
2.5
7.5
CEILING
CEILING
Returns the smallest integer value that is greater than or equal to the value.
input
result
5.9
6
-5.9
-5
COS
COS
Returns the cosine of the value in radians.
input
result
0.785
0.707
1.05
0.5
1.57
6.12E-17
2.09
-0.5
1.57
6.12E-17
DEGREES
DEGREES
Converts the specified radians to degrees.
input
result
0
0
3.14
180
6.28
360
DIVIDE
DIVIDE
Divides the first number by the second.
operand 1
operand 2
result
5.1
2.5
2.04
5
2.5
2
5
0
null
EXP
EXP
A mathematical function that returns the exponential value of the specified number where is the input value.
input
result
1
2.72
2
7.39
3
20.1
NaN
NaN
FLOOR
FLOOR
Returns the largest integer value that is equal to or less than the value.
input
result
5.9
5
-5.9
-6
GET_PROCESSING_TIME
GET_PROCESSING_TIME
Gets the task time.
Inputs
time
— Must be the time field from the data.
GREATEST
GREATEST
Return the maximum value.
inputs
result
[1, 0.2]
, [30]
30
INTEGER_DIVIDE
INTEGER_DIVIDE
Divides the first number by the second and returns the integer part of the result.
operand 1
operand 2
result
5.1
2.5
2
5
2.5
2
-5.1
2.5
-2
3
0
null
0
0
null
0
3
null
LN
LN
Returns the natural logarithm of the input.
Input
such that
Return value
or where
input
result
0.5
-0.693
1
0
2
0.693
0
null
-1
null
LOG
LOG
Returns the logarithm of input .
Input
such that
base — The base to use for the logarithm.
Return value
base
result
2
2.0
1
4
2.0
2
8
2.0
3
1
10.0
0
10
10.0
1
100
10.0
2
-2
2.0
null
MOD
MOD
Returns the remainder of the first number divided by the second.
operand 1
operand 2
result
5
2
1
5.3
2.2
0.9
5
-2
1
MULTIPLY
MULTIPLY
Multiplies two numbers.
operand 1
operand 2
result
5.1
2.5
12.8
5
2.5
12.5
NEGATE
NEGATE
Negates the input value.
input
result
1
-1
-1
1
POWER
POWER
A mathematical function that raises the first value to the power of the second value.
Inputs
base
exponent
base
exponent
result
2
0
1
2
1
2
2
2
4
2
3
8
2
4
16
RADIANS
RADIANS
Converts the specified degrees to radians.
input
result
0
0
180
3.14
360
6.28
RECIPROCAL
RECIPROCAL
Returns the reciprocal where is the input value.
input
result
2
0.5
4
0.25
1
1
0
null
ROUND
ROUND
Returns the value rounded to a certain number of decimal places.
Inputs
value — The number to round.
precision — The number of decimal places to keep; defaults to 0.
value
precision
result
2.365
1
2.4
2.345
1
2.3
2.345
2
2.35
2.345
2
2.345
0
2
SIGN
SIGN
Returns a value (1, 0, or -1) indicating the sign of the value.
input
result
5
1
0
0
-5.5
-1
SIN
SIN
Returns the sine of the value in radians.
input
result
0.785
0.707
1.05
0.866
1.57
1
2.09
0.866
1.57
1
SQRT
SQRT
A mathematical function that returns the square root of the value.
input
result
4
2
-2
null
SQUARE
SQUARE
A mathematical function that returns the square of the value.
input
result
2
4
-2
4
SUBTRACT
SUBTRACT
Subtracts the second number from the first.
operand 1
operand 2
result
5.1
2.5
2.6
5
2.5
2.5
TAN
TAN
Returns the tangent of the value in radians using Java's Math.tan
method.
input
result
-1.57
-1.63E16
-0.785
-1.0
0.0
0.0
0.785
1.0
1.57
1.63E16
TAN_H
TAN_H
Returns the hyperbolic tangent of the value in radians using Java's Math.tanh
method.
input
result
-1.57
-0.917
-0.785
-0.656
0.0
0.0
0.785
0.656
1.57
0.917
TRUNC
TRUNC
Returns the value truncated to a certain number of decimal places.
Inputs
value - The number to truncate.
precision - The number of decimal places to keep; defaults to 0.
value
precision
result
2.365
1
2.3
2.345
1
2.3
2.345
2
2.34
2.345
2
2.345
0
2
Last updated