Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
The Ceiling()
function rounds a number up to an integral value (integer number without decimals) larger than or equal to the given number.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the closest integral value that is larger than or equal to number
.
Returns Invalid expression
if the parameter is not a valid number.
Name | Type | Required | Description |
---|---|---|---|
Function call | Result |
---|---|
Ceiling(5)
5
Ceiling(5.0001)
6
Ceiling(123.123)
124
Ceiling(-123.89)
-123
number
numeric
a number
The Abs()
function takes the absolute value of a number.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns an absolute number
Returns Invalid expression
if the parameter is not a valid number.
The Cos()
calculates the cosine of a given radian value.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns cosine of number
Returns invalid expression
if the parameter has no value or is not a valid number.
The Distance()
function returns the geographical distance (in kilometers - as the crow flies) between two points of (latitude
,longitude
).
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the geographical distance (in kilometers - in a straight line) between two geographical points.
Returns Invalid expression
if one of the parameter values is not a valid number.
Name | Type | Required | Description |
---|---|---|---|
Function call | Result |
---|---|
Name | Type | Required | Description |
---|---|---|---|
Function call | Result |
---|---|
Name | Type | Required | Description |
---|---|---|---|
Function call | Result |
---|---|
Abs(123.456)
123.456
Abs(-123.456)
123.456
Abs(1.23456*10^6)
1234560
cos(1)
0.5403023059
cos(Pi)
-1
cos(Pi/2)
0
Distance(52.370216, 4.895168, -37.814, 14496332)
16545.7337
Returns the value of Pi with 10 decimals.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
number
numeric
a number
rad
numeric
a number given in unit of radians
latitude1
numeric
a geographic coordinate that specifies the north–south position of a point on the Earth's surface in decimal degrees.
longtitude1
numeric
a geographic coordinate that specifies the east-west position of a point on the Earth's surface decimal degrees.
latitude2
numeric
a geographic coordinate that specifies the north–south position of a point on the Earth's surface in decimal degrees.
longtitude2
numeric
a geographic coordinate that specifies the east-west position of a point on the Earth's surface decimal degrees.
The Log()
function calculates the natural logarithm (base e
) of a given number, or calculates the logarithm of a number by specified base.
Read wiki for more info about logarithm.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the logarithm of a givennumber
, using base e
or a specified base number.
Returns Invalid expression
if one of the parameter values is not a valid number.
Name | Type | Required | Description |
---|---|---|---|
Function call | Result |
---|---|
Log(5)
1.6094
Log(25, 5)
2
Log(5, 25)
0.5
number
numeric
a numeric value.
base
numeric
a numeric value.
The Pow()
function calculates a number to the power of another number.
The operator ^ can also be used to do power-calculation.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a number
.
Returns Invalid expression
if one of the parameter values is not a valid number, and returns unknown
if one of the parameters is unknown.
Name | Type | Required | Description |
---|---|---|---|
Function call | Result |
---|---|
Pow(1, 0)
1
Pow(0, 1)
0
Pow(2, 3)
8
Pow(0.5, -0.5)
1.4142135624
Pow(-0.5, 0.5)
NaN (not a number)
Pow(1234, 1234)
infinity
number
numeric
a number
power
numeric
a number
The Round()
function rounds a number.
Rounding a number can be done according to different strategies when it comes to the edge cases (like x.5). WEM uses the Banker's Rounding strategy because of its statistical superiority and standard use in financial and statistical operations. Mind, this only applies to the Mid-Point values: the middle of the spectrum, where a decision needs to be made which way to go. So if you expect 3.85 to be rounded to 3.9 (away from zero), you'll be surprised to see WEM shows 3.8 (Banker's).
Returns a number that is rounded to an integral number or a number of fractional digits.
Returns Invalid expression
if one of the parameter values is not a valid number.
Read about rounding strategies.
This function is NOT SQL compatible. For more information about SQL compatibility, see our .
Name | Type | Required | Description |
---|
Function call | Result |
---|
Round(5.499) | 5 |
Round(5.501) | 6 |
Round(3.85, 1) | 3.8 |
Round(5.489, 2) | 5.49 |
Round(5.499, 2) | 5.50 |
| numeric | a number |
| numeric | the number of fractional digits |
The Sqrt()
function calculates the square root of a number.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a number that is the square root of a givennumber
.
Returns Invalid expression
if the parameter is not a valid number.
The Sin()
function calculates the sine of a number given in radians.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the sine of a number.
Returns Invalid expression
if rad
has no value.
The Exp() function calculates the e-number
raised to the power n, where n is an number.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a number.
Returns Invalid expression
if the parameter is not a valid number.
The Floor()
function rounds down to the closest integral number (integer number without decimals) smaller than or equal to the given number.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the closest integral value that is smaller than or equal to number
.
Returns Invalid expression
if the parameter is not a valid number.
The Log10()
function calculates the base-10 logarithm of a given number.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the base-10 logarithm of number
.
Returns Invalid expression
if the parameter value is not a valid number.
The ToNumber()
converts a value to a number.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Note: this function uses the language setting of a portal when converting text.
Returns the number converted from text
or a unit from date
.
Returns Invalid expression
when text
is not a number, or when reference
is not a valid RowId, or when date
is not a valid date value or unit
is not a valid date unit.
Name | Type | Required | Description |
---|---|---|---|
Function call | Result |
---|---|
Name | Type | Required | Description |
---|---|---|---|
Function call | Result |
---|---|
Name | Type | Required | Description |
---|---|---|---|
Function call | Result |
---|---|
Name | Type | Required | Description |
---|---|---|---|
Function call | Result |
---|---|
Name | Type | Required | Description |
---|---|---|---|
Function call | Result |
---|---|
Name | Type | Required | Description |
---|---|---|---|
Sqrt(100)
10
Sqrt(9)
3
Sqrt(2)
1.4142135623731
Sin(0)
0
Sin(Pi/2)
1
Sin(1)
0.8414709848078965
Exp(0)
1
Exp(-0.6)
0.548812
Exp(-1000)
0
Exp(10)
22026.4658
Floor(5)
5
Floor(5.999)
5
Floor(-123.89)
-124
Log10(0)
(no value)
Log10(100000)
5
Log10(0.00005)
-4.3010299957
Log10(-20)
(no value)
number
numeric
a number.
rad
numeric
a number given in unit of radians.
number
numeric
a numeric value.
number
numeric
a numeric value.
number
numeric
a numeric value.
text
text
a text containing a number.
reference
reference
reference field, holding a rowid of a list.
date
date
a date.
unit
text
the unit that is retrieved from date
.
The Random()
generates a random number.
Returns a random integral number between 0 or a minimum value, and a maximum value.
Returns Invalid expression
if one of the parameter values is not a valid number, or is a negative number, or when a maximum value is 0, or when a maximum value is less than a minimum value.
This function is NOT SQL compatible. For more information about SQL compatibility, see our .
Name | Type | Required | Description |
---|
| numeric | the maximum value of the generated number. |
| numeric | the minimum value of the generated number. |