Formulas
      Back to home
      1. Knowledge Base
      2. Formulas

      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