Numeric functions
This page goes over the numeric functions in Upsolver.
ABS
ABSReturns the absolute value of a number.
input
result
5
5
-3
3
0
0
ADD
ADDAdds two numbers together.
operand 1
operand 2
result
5.1
2.5
7.6
5
2
7
5
2.5
7.5
CEILING
CEILINGReturns the smallest integer value that is greater than or equal to the value.
input
result
5.9
6
-5.9
-5
COS
COSReturns 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
DEGREESConverts the specified radians to degrees.
input
result
0
0
3.14
180
6.28
360
DIVIDE
DIVIDEDivides 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
EXPA 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
FLOORReturns 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_TIMEGets the task time.
Inputs
time— Must be the time field from the data.
GREATEST
GREATESTReturn the maximum value.
inputs
result
[1, 0.2], [30]
30
INTEGER_DIVIDE
INTEGER_DIVIDEDivides 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
LNReturns 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
LOGReturns 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
MODReturns 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
MULTIPLYMultiplies two numbers.
operand 1
operand 2
result
5.1
2.5
12.8
5
2.5
12.5
NEGATE
NEGATENegates the input value.
input
result
1
-1
-1
1
POWER
POWERA 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
RADIANSConverts the specified degrees to radians.
input
result
0
0
180
3.14
360
6.28
RECIPROCAL
RECIPROCALReturns the reciprocal where is the input value.
input
result
2
0.5
4
0.25
1
1
0
null
ROUND
ROUNDReturns 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
SIGNReturns a value (1, 0, or -1) indicating the sign of the value.
input
result
5
1
0
0
-5.5
-1
SIN
SINReturns 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
SQRTA mathematical function that returns the square root of the value.
input
result
4
2
-2
null
SQUARE
SQUAREA mathematical function that returns the square of the value.
input
result
2
4
-2
4
SUBTRACT
SUBTRACTSubtracts the second number from the first.
operand 1
operand 2
result
5.1
2.5
2.6
5
2.5
2.5
TAN
TANReturns 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_HReturns 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
TRUNCReturns 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
Was this helpful?