Scalar functions

Mathematical functions

Function NameDescription
abs()Calculates the absolute value of the input.
acos()Returns the angle whose cosine is the specified number (the inverse operation of cos()).
asin()Returns the angle whose sine is the specified number (the inverse operation of sin()).
atan()Returns the angle whose tangent is the specified number (the inverse operation of tan()).
atan2()Calculates the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x).
cos()Returns the cosine function.
degrees()Converts angle value in radians into value in degrees, using formula degrees = (180 / PI) * angle-in-radians.
exp()The base-e exponential function of x, which is e raised to the power x: e^x.
exp2()The base-2 exponential function of x, which is 2 raised to the power x: 2^x.
gamma()Computes gamma function.
isinf()Returns whether input is an infinite (positive or negative) value.
isnan()Returns whether input is Not-a-Number (NaN) value.
log()Returns the natural logarithm function.
log10()Returns the common (base-10) logarithm function.
log2()Returns the base-2 logarithm function.
loggamma()Computes log of absolute value of the gamma function.
not()Reverses the value of its bool argument.
pi()Returns the constant value of Pi (π).
pow()Returns a result of raising to power.
radians()Converts angle value in degrees into value in radians, using formula radians = (PI / 180) * angle-in-degrees.
round()Returns the rounded source to the specified precision.
sign()Sign of a numeric expression.
sin()Returns the sine function.
sqrt()Returns the square root function.
tan()Returns the tangent function.
exp10()The base-10 exponential function of x, which is 10 raised to the power x: 10^x.
isint()Returns whether input is an integer (positive or negative) value
isfinite()Returns whether input is a finite value (is neither infinite nor NaN).

abs()

Calculates the absolute value of the input.

Arguments

  • x: An integer or real number, or a timespan value.

Returns

  • Absolute value of x.

Example

abs(x)

acos()

Returns the angle whose cosine is the specified number (the inverse operation of cos()) .

Arguments

x: A real number in range [-1, 1].

Returns

  • The value of the arc cosine of x
  • null if x < -1 or x > 1

Example

acos(x)

asin()

Returns the angle whose sine is the specified number (the inverse operation of sin()) .

Arguments

  • x: A real number in range [-1, 1].

Returns

  • The value of the arc sine of x
  • null if x < -1 or x > 1

Example

asin(x)

atan()

Returns the angle whose tangent is the specified number (the inverse operation of tan()) .

Arguments

x: A real number.

Returns

The value of the arc tangent of x

Example

atan(x)

atan2()

Calculates the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x).

Arguments

x: X coordinate (a real number). y: Y coordinate (a real number).

Returns

The angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x).

Example

atan2(y,x)

cos()

Returns the cosine function.

Arguments

x: A real number.

Returns

The result of cos(x)

Example

cos(x)

degrees()

Converts angle value in radians into value in degrees, using formula degrees = (180 / PI ) * angle_in_radians

Arguments

a: Angle in radians (a real number).

Returns

The corresponding angle in degrees for an angle specified in radians.

Examples

degrees(a)

exp()

The base-e exponential function of x, which is e raised to the power x: e^x.

Example

exp(x)

Arguments

x: A real number, value of the exponent.

Returns

  • Exponential value of x.
  • For natural (base-e) logarithms, see log().
  • For exponential functions of base-2 and base-10 logarithms, see exp2(), exp10()

exp2()

The base-2 exponential function of x, which is 2 raised to the power x: 2^x.

Example

exp2(x)

Arguments

x: A real number, value of the exponent.

Returns

  • Exponential value of x.
  • For natural (base-2) logarithms, see log2().
  • For exponential functions of base-e and base-10 logarithms, see exp(), exp10()

gamma()

Computes gamma function

Example

gamma(x)

Arguments

  • x: Parameter for the gamma function

Returns

  • Gamma function of x.
  • For computing log-gamma function, see loggamma().

isinf()

Returns whether input is an infinite (positive or negative) value.

Example

isinf(x)

Arguments

x: A real number.

Returns

A non-zero value (true) if x is a positive or negative infinite; and zero (false) otherwise.

isnan()

Returns whether input is Not-a-Number (NaN) value.

Example

isnan(x)

Arguments

x: A real number.

Returns

A non-zero value (true) if x is NaN; and zero (false) otherwise.

log()

log() returns the natural logarithm function.

Example

log(x)

Arguments

x: A real number > 0.

Returns

The natural logarithm is the base-e logarithm: the inverse of the natural exponential function (exp). null if the argument is negative or null or can't be converted to a real value.

log10()

log10() returns the common (base-10) logarithm function.

Example

log10(x)

Arguments

x: A real number > 0.

Returns

The common logarithm is the base-10 logarithm: the inverse of the exponential function (exp) with base 10. null if the argument is negative or null or can't be converted to a real value.

log2()

log2() returns the base-2 logarithm function.

Example

log2(x)

Arguments

x: A real number > 0.

Returns

The logarithm is the base-2 logarithm: the inverse of the exponential function (exp) with base 2. null if the argument is negative or null or can't be converted to a real value.

loggamma()

Computes log of absolute value of the gamma function

Example

loggamma(x)

Arguments

x: Parameter for the gamma function

Returns

  • Returns the natural logarithm of the absolute value of the gamma function of x.

not()

Reverses the value of its bool argument.

Example

not(expr)

Arguments

expr: A bool expression to be reversed.

Returns

Returns the reversed logical value of its bool argument.

pi()

Returns the constant value of Pi.

Example

pi()

Returns

  • The double value of Pi (3.1415926...)

pow()

Returns a result of raising to power

Example

pow(base, exponent )

Arguments

  • base: Base value.
  • exponent: Exponent value.

Returns

Returns base raised to the power exponent: base ^ exponent.

radians()

Converts angle value in degrees into value in radians, using formula radians = (PI / 180 ) * angle_in_degrees

Example

radians(a)

Arguments

a: Angle in degrees (a real number).

Returns

The corresponding angle in radians for an angle specified in degrees.

round()

Returns the rounded source to the specified precision.

Example

round(source [, Precision])

Arguments

  • source: The source scalar the round is calculated on.
  • Precision: Number of digits the source will be rounded to.(default value is 0)

Returns

The rounded source to the specified precision.

sign()

Sign of a numeric expression

Example

sign(x)

Arguments

  • x: A real number.

Returns

  • The positive (+1), zero (0), or negative (-1) sign of the specified expression.

sin()

Returns the sine function.

Example

sin(x)

Arguments

x: A real number.

Returns

The result of sin(x)

sqrt()

Returns the square root function.

Example

sqrt(x)

Arguments

x: A real number >= 0.

Returns

  • A positive number such that sqrt(x) sqrt(x) == x*
  • null if the argument is negative or cannot be converted to a real value.

tan()

Returns the tangent function.

Example

tan(x)

Argument

  • x: A real number.

Returns

  • The result of tan(x)

exp10()

The base-10 exponential function of x, which is 10 raised to the power x: 10^x.

Example

exp10(x)

Arguments

x: A real number, value of the exponent.

Returns

  • Exponential value of x.
  • For natural (base-10) logarithms, see log10().
  • For exponential functions of base-e and base-2 logarithms, see exp(), exp2()

isint()

Returns whether input is an integer (positive or negative) value.

Arguments

  • Expr: expression value which can be a real number

Returns

A non-zero value (true) if expression is a positive or negative integer; and zero (false) otherwise.

Example

isint(expression)
isint(resp_body_size_bytes) == true

isfinite()

Returns whether input is a finite value (is neither infinite nor NaN).

Arguments

  • number: A real number.

Returns

A non-zero value (true) if x is finite; and zero (false) otherwise.

Example

isfinite(number)

Was this page helpful?