Number functions
- Article
-
-
These functions create and manipulate number values.
Name |
Description |
Byte.From |
Returns an 8-bit integer number value from the given value. |
Currency.From |
Returns a currency value from the given value. |
Decimal.From |
Returns a decimal number value from the given value. |
Double.From |
Returns a Double number value from the given value. |
Int8.From |
Returns a signed 8-bit integer number value from the given value. |
Int16.From |
Returns a 16-bit integer number value from the given value. |
Int32.From |
Returns a 32-bit integer number value from the given value. |
Int64.From |
Returns a 64-bit integer number value from the given value. |
Number.From |
Returns a number value from a value. |
Number.FromText |
Returns a number value from a text value. |
Number.ToText |
Converts the given number to text. |
Percentage.From |
Returns a percentage value from the given value. |
Single.From |
Returns a Single number value from the given value. |
Name |
Description |
Number.Round |
Returns a nullable number (n) if value is an integer. |
Number.RoundAwayFromZero |
Returns Number.RoundUp(value) when value >= 0 and Number.RoundDown(value) when value < 0. |
Number.RoundDown |
Returns the largest integer less than or equal to a number value. |
Number.RoundTowardZero |
Returns Number.RoundDown(x) when x >= 0 and Number.RoundUp(x) when x < 0. |
Number.RoundUp |
Returns the larger integer greater than or equal to a number value. |
Name |
Description |
Number.Abs |
Returns the absolute value of a number. |
Number.Combinations |
Returns the number of combinations of a given number of items for the optional combination size. |
Number.Exp |
Returns a number representing e raised to a power. |
Number.Factorial |
Returns the factorial of a number. |
Number.IntegerDivide |
Divides two numbers and returns the whole part of the resulting number. |
Number.Ln |
Returns the natural logarithm of a number. |
Number.Log |
Returns the logarithm of a number to the base. |
Number.Log10 |
Returns the base-10 logarithm of a number. |
Number.Mod |
Divides two numbers and returns the remainder of the resulting number. |
Number.Permutations |
Returns the number of total permutations of a given number of items for the optional permutation size. |
Number.Power |
Returns a number raised by a power. |
Number.Sign |
Returns 1 for positive numbers, -1 for negative numbers or 0 for zero. |
Number.Sqrt |
Returns the square root of a number. |