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