Numeric Operations
Abs()
This function returns the absolute value (without negative sign) of a number.
Return type: number
Parameter | Data Type | Description |
|---|---|---|
1 | Number | Number whose absolute value is to be determined |
Examples
Abs(-123) returns 123.
CanParseAsNumber()
This function checks whether a text value can be interpreted.
Return type: Boolean
Parameter | Data Type | Description |
|---|---|---|
1* | Text | Value to be checked |
2 | Text | Specification of the decimal separator used (comma or period) (optional) |
Examples
CanParseAsNumber(" -123.45") returns TRUE.
CanParseAsNumber("123.45-") returns FALSE.
GetRandomNumber()
This function returns a randomly generated integer.
Return type: number
Parameter | Data Type | Description |
|---|---|---|
1 | Number | Lower limit of the value range Default value: |
2 | Number | Upper limit of the value range Default value: |
Examples
GetRandomNumber(1, 100) returns a number between 1 and 100 (e.g., 29).
IsNumber()
This function checks whether a value is of the data type "Number."
Return type: Boolean
Parameter | Data Type | Description |
|---|---|---|
1* | (variable) | Value to be checked |
Examples
IsNumber(123.45) returns TRUE.
IsNumber("123.45") returns FALSE.
ParseAsNumber()
This function converts a text value to a numeric value.
Return type: number
Parameter | Data Type | Description |
|---|---|---|
1* | Text | Value to be converted |
2 | Text | Specification of the decimal separator used (comma or period) (optional) |
Examples
ParseAsNumber("1.234,56") returns 1234.56.
ParseAsNumber("1,234", ".") returns 1234.
ParseAsNumber("1,234", ",") returns 1,234 (with the comma interpreted as a thousands separator).
Round()
This function returns the value of a fractional number rounded to a specified number of decimal places.
As a rounding procedure, values that are exactly between two target values are rounded to the value that has the larger absolute value.
Return type: number
Parameter | Data Type | Description |
|---|---|---|
1 | Number | Numeric value to be rounded |
2 | Number | Number of decimal places to which rounding is performed Default value: |
Examples
Round(1.234, 2) returns 1.23.
Round(1.235, 2) returns 1.24.