ABS

ABS(Value)

Calculates the absolute value of a number.

ParameterTypeDescription
ValueNumber/EachValue to check.
→ ResultNumberAbsolute value of Value.

Examples:

  • ABS(5) → 5
  • ABS(-4) → 4

CEILING

CEILING(Value; N)

Rounds value up to the Nth decimal place.

ParameterTypeDescription
ValueNumber/EachNumber to round.
N (Optional)IntegerHow many decimal places to round up to. Negative numbers round up to tens, hundreds, etc. Default value: 0 (round to an integer).
→ ResultNumberValue rounded up to the Nth place.

Examples:

  • CEILING(1.678) → 2
  • CEILING(12.34; 1) → 12.4
  • CEILING(12.34; -1) → 20
  • CEILING(-3.14) → -3

FLOOR

FLOOR(Value; N)

Rounds value down to the Nth decimal place.

ParameterTypeDescription
ValueNumber/EachNumber to round.
N (Optional)IntegerHow many decimal places to round down to. Negative numbers round down to tens, hundreds, etc. Default value: 0 (round to an integer).
→ ResultNumberValue rounded down to the Nth place.

Examples:

  • FLOOR(1.678) → 1
  • FLOOR(12.34; 1) → 12.3
  • FLOOR(17.34; -1) → 10
  • FLOOR(-3.14) → -4

LN

LN(x)

Returns the logarithm for 'x' with base of e.

ParameterTypeDescription
xNumberValue to check
→ ResultNumberlogarithm for x with a base of e

LOG

LOG(x), LOG(x,b)

LOG(x) returns the logarithm for 'x' with base of 10. LOG(x,b) returns the logarithm for 'x' with base of 'b'.

ParameterTypeDescription
xNumberValue to check

b

(Optional)

Number

Base value.

If omitted or an empty value is entered, uses base 10.

→ ResultNumberlogarithm for x

Example - the following will categorize projects based on the logarithm of all the story points within them:

WITH projectSize = LOG(SUM{storypoints}):
IF(
projectSize < 1; "Small";
projectSize < 2; "Medium";
projectSize >= 2; "Large"
)

LOG10

LOG10(x)

Returns the logarithm for 'x' with base of 10. Same as LOG with only an x variable.

ParameterTypeDescription
xNumberValue to check
→ ResultNumberlogarithm for x

MOD

MOD(A; N)

Returns the remainder from dividing A by N.

ParameterTypeDescription
AInteger/EachThe dividend, must be an integer.
NIntegerThe divisor, must be an integer.
→ ResultNumberThe remainder from dividing A by N.

Example:

  • MOD(17; 5) → 2

MUL

MUL(Value1, Value2,...)

MUL(A)

Short for "multiply" - produces the product of all values passed as arguments. When used with an array, produces the product of all values in the array. 

ParameterTypeDescription

Value1, Value2, ..., ValueN

OR

A

Number


Array

Series of number values.


Array containing numeric elements.

→ ResultInteger

Product of all numeric elements.

Undefined values are ignored. Non-numeric values result in an error.

Example:

  • MUL(2, 3, 5) → 30
  • MUL(ARRAY(1, 2, 3, 4)) → 24

NUMBER

NUMBER(Value, DefaultOpt)

Converts value to number. This function is rarely needed, because conversion to number happens automatically when needed.

ParameterTypeDescription
ValueAnyValue to convert
Default (Optional)NumberOptional. If provided and Value cannot be converted to a number, this function returns the Default rather than an error.
→ ResultNumberValue converted to a number.

Example:

  • NUMBER("1.234") → 1.234

POW

POW(B; E)

Produces B to the power of E (BE). Both values can be fractional.

ParameterTypeDescription
BNumber/EachBase
ENumberExponent
→ ResultNumberB to the power of E (BE)

Example:

  • POW(3; 3) → 27
  • POW(27; 1/3) → 3

ROUND

ROUND(Value, N)

Rounds value to the Nth decimal place.

ParameterTypeDescription
ValueNumber/EachA number to round.
N (Optional)IntegerHow many decimal places to round to. Negative numbers round to the nearest tens, hundreds, etc. Default value: 0 (round to an integer).
→ ResultNumberValue rounded to the Nth place.

Examples:

  • ROUND(1.678) → 2
  • ROUND(12.34, 1) → 12.3
  • ROUND(12.34, -1) → 10
  • ROUND(ARRAY(1.1, 2.6)) → ARRAY(1, 3)

SIGN

SIGN(Value)

Returns the sign of the Value (1 for positive, -1 for negative).

ParameterTypeDescription
ValueNumber/EachValue to check.
→ ResultNumberReturns 1 if Value is positive, -1 if Value is negative.

Examples:

  • SIGN(123) → 1
  • SIGN(0) → 0
  • SIGN(-123) → -1

SQR

SQR(Value)

Returns the passed numerical value, squared.

ParameterTypeDescription
ValueNumber/EachNumerical value.
→ ResultNumberValue2

Example:

  •  SQR(5) → 25

SQRT

SQRT(Value)

Returns the square root of the passed numerical value.

ParameterTypeDescription
ValueNumber/EachNumerical value.
→ ResultNumber√Value

Example:

  • SQRT(25) → 5

SUM

SUM(Number1, Number2, ...)

SUM(A)

Produces the total of all numeric values passed as arguments. When used with an array, produces a total of all numeric elements in the array.

ParameterTypeDescription

Number1, Number2, ..., NumberN)

OR

A

Number


Array

Array containing numeric elements.

→ ResultInteger

Sum of all numeric elements.

Undefined values are ignored. Non-numeric values (that cannot be converted to numbers) result in an error.

Example:

  • SUM(1; 3; 5) → 9
  • SUM(ARRAY(1, 2, 3, 4)) → 10