Number functions
Article
07/18/2023
4 contributors
Feedback
In this 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.
Rounding
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.
Operations
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.
Random
Trigonometry
Bytes