Formulas
      Back to home
      1. Knowledge Base
      2. Formulas

      Calculations

      Perform calculation on fields with the input type number

      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.

      SIN(90) = 1

      SQRT

      This function returns the square root of the input value.

      Example

      SQRT(9) = 3