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