Skip to content
English
Sign in
omniaretail.com
  • There are no suggestions because the search field is empty.

Calculations

Perform calculation on fields with the input type number

In addition to utilizing tags in the mapping configuration for imports and reports, calculations can also be employed. Below are a few illustrative examples.

IEEEREMAINDER

Returns the remainder after a defined number is divided by a defined divisor. The result has the same sign as divisor. IEEERemainder = number - (divisor * Round(number / divisor)).

Example

IEEEREMAINDER(3/2) = 1

IEEEREMAINDER(17.8/4) = 1.8

IEEEREMAINDER(10/3) = 1

MAX

This function returns the larger of two specified numbers.

Example

MAX(1,2) = 2

MIN

This function returns the smaller of two specified numbers.

Example

MIN(1,2) = 1

POW

This function returns the result of a number raised to a given power.

Example

POW(4,3) = 4^3 = 64

SIN

This function returns the sine of the input.

Example

SIN(90) = 1

SQRT

This function returns the square root of the input value.

Example

SQRT(9) = 3