Number

3 minutes to read

Mathematical operators and static constants including basic arithmetic and random numbers.

Numeric field

Fixed value for any number. It can be used to assign a static value to a table field or any other place that accepts a number datatype.

Mathematical operations

Mathematical operations such as addition, subtraction, division, multiplication, and operations with modulo (%) that return the remainder of a division operation.

Negative number

Negative value negating the given value. It can be used to create an inversed (opposite) number that can be employed in calculations or file field assignments.

Arithmetic operations, floor and ceiling functions, logarithms

Arithmetic, rounding, and logarithmic mathematical operations and processes.

The following options are available:

Absolute – returns the absolute value of a number. For example, absolute from (-200) is 200.
Square root – returns the square root of a number. For example, the square root from 64 is 8.0.
Square – returns the square of a number. For example, the square of 64 is 4096.0.
Power – returns the value of a number raised to the power of another number. For example, the power of (4, 2) is 16.
Round – rounds the number to 2 decimal places. For example, the round of 235.415 to 2 decimal places is 235.420. Negative argument for decimal places rounds the integer part. For example, the round of 235.415 to -2 decimal places is 200.00.
Ceiling – returns the smallest integer value that is greater than or equal to a number. For example, the ceiling of 81.75 is 82.0.
Floor – returns the largest integer value that is smaller than or equal to a number. For example, the floor of 81.75 is 81.
logx(y) – returns the logarithm of a number by the specified base value. For example, log of 2 to a base 4 is 0.5.
In – returns the natural logarithm of a number. It is logarithm to the base of the mathematical constant e.
log10 – returns the decimal logarithm of a number. It is a logarithm to the base of 10. For example, log(10)2 is 0.3010299956639812.
ex – returns math constant e raised to the power of a specified number. For example, e raised to the power 2 is 7.3890560989306504.
10x – returns 10 raised to the power of a specified number. For example, 10 raised to the power 3 is 1000.

The above example presents geometrical mean calculated from all records in the Transactions table according to the following formula:

Random number

Random number returns a random decimal fraction, that is the number between 0 (inclusive) and 1 (exclusive).

The above triggered action generates a coupon code for a newly inserted client by using a random number block and sets the expiration date to one year. Then, it sends an email to the client with a notification that the coupon is available.

Sign of

Sign of returns the sign of a number as follows:

If number > 0, it returns 1
If number = 0, it returns 0
If number < 0, it returns –1

It can be used to analyze the month-over-month change in a company’s net income. If Sign of returns 1, it indicates a positive growth in net income; if it returns 0, there is no change; and if it returns -1, there is a decline in net income.

N(pi)

N(pi) returns Pi number value.

The above trigger calculates the surface area of a circle (πr²) that is required for ordering purposes.