Skip to Content

Math functions in Jitterbit Integration Studio

The math functions provide additional mathematical operators beyond the basic arithmetical operators of Jitterbit Script.

Ceiling

Declaration

int Ceiling(double d)

Syntax

Ceiling(<d>)

Required parameters

  • d: A double value

Description

Returns the mathematical ceiling (rounded up to the nearest integer) of a given value as an integer. The argument should be a double and is first converted to a double if not.

Examples

Ceiling(52.154); // Returns a value of 53

Exp

Declaration

double Exp(double d)

Syntax

Exp(<d>)

Required parameters

  • d: A double value

Description

Returns the mathematical result e^d, or e to the power of d. The argument should be a double and is first converted to a double if not.

Examples

Exp(4.60517); // Returns a value of 100 (99.9999814011926)

Floor

Declaration

int Floor(double d)

Syntax

Floor(<d>)

Required parameters

  • d: A double value

Description

Returns the mathematical floor (rounded down to the nearest integer) of a given value as an integer. The argument should be a double and is first converted to a double if not.

Examples

Floor(52.654); // Returns a value of 52

Log

Declaration

double Log(double d)

Syntax

Log(<d>)

Required parameters

  • d: A double value

Description

Returns the natural log (logarithm to the base e) of a given value. The argument should be a double and is first converted to a double if not.

Examples

Log(100); // Returns a value of 4.60517018598809
Log("5a"); // Returns 1.6094379124341
// Treated as if Log(5)

Log10

Declaration

double Log10(double d)

Syntax

Log10(<d>)

Required parameters

  • d: A double value

Description

Returns the logarithm to the base 10 of a given value. The argument should be a double and is first converted to a double if not.

Examples

log10(100); // Returns a value of 2

log10("5a"); // Returns 0.698970004336019
// Treated as if Log10(5)

Mod

Declaration

long Mod(long numerator, long denominator)

Syntax

Mod(<numerator>, <denominator>)

Required parameters

  • numerator: A long value
  • denominator: A long value

Description

Calculates the modulus (the remainder) of the division of the numerator by the denominator. The return value has the same sign as the numerator. If the denominator is 0, the numerator is returned.

Examples

Mod(3005, 1000); // Returns 5
Mod(204, 17); // Returns 0
Mod(-206, 17); // Returns -2

Pow

Declaration

double Pow(double base, double exponent)

Syntax

Pow(<base>, <exponent>)

Required parameters

  • base: A double value,
  • exponent: A double value

Description

Returns the mathematical result base^exponent, or base to the power of exponent. The arguments should be doubles and are first converted to doubles if not.

Examples

Pow(2,3); // Returns a value of 8

Round

Declaration

string Round(double d[, int numPlaces])

Syntax

Round(<d>[, <numPlaces>])

Required parameters

  • d: A double value

Optional parameters

  • numPlaces: An integer number of places of precision. If omitted, the default is 0.

Description

Returns the given value rounded to a specified precision and then converted to a string. The argument should be a double and is first converted to a double if not. This function is designed for displaying values (not computing) as the output is a string.

This function is similar to the String Format function.

Examples

Round(9.53537465, 4); // Returns the string "9.5354"

RoundToInt

Declaration

int RoundToInt(double d)

Syntax

RoundToInt(<d>)

Required parameters

  • d: A double value

Description

Returns the given value rounded to the nearest integer (no decimal places). The argument should be a double and is first converted to a double if not.

Examples

RoundToInt(9.5353); // Returns a value of 10

Sqrt

Declaration

double Sqrt(double d)

Syntax

Sqrt(<d>)

Required parameters

  • d: A double value

Description

Returns the square root of a given value. The argument should be a double and is first converted to a double if not.

Examples

Sqrt(9); // Returns a value of 3