Numeric Functions

ABS

ABS(Value)

Calculates the absolute value of a number.

Parameter	Type	Description
`Value`	`Number/Each`	Value to check.
→ Result	`Number`	Absolute value of `Value`.

Examples:

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

CEILING

CEILING(Value; N)

Rounds value up to the N^th decimal place.

Parameter	Type	Description
`Value`	`Number/Each`	Number to round.
`N` (Optional)	`Integer`	How many decimal places to round up to. Negative numbers round up to tens, hundreds, etc. Default value: `0` (round to an integer).
→ Result	`Number`	`Value` rounded up to the `N`^th 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 N^th decimal place.

Parameter	Type	Description
`Value`	`Number/Each`	Number to round.
`N` (Optional)	`Integer`	How many decimal places to round down to. Negative numbers round down to tens, hundreds, etc. Default value: `0` (round to an integer).
→ Result	`Number`	`Value` rounded down to the `N`^th 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.

Parameter	Type	Description
`x`	`Number`	Value to check
→ Result	`Number`	logarithm 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'.

Parameter

Type

Description

x

Number

Value to check

b

(Optional)

Number

Base value.

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

→ Result

Number

logarithm 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.

Parameter	Type	Description
`x`	`Number`	Value to check
→ Result	`Number`	logarithm for x

MOD

MOD(A; N)

Returns the remainder from dividing A by N.

Parameter	Type	Description
`A`	`Integer/Each`	The dividend, must be an integer.
`N`	`Integer`	The divisor, must be an integer.
→ Result	`Number`	The 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.

Parameter

Type

Description

Value1, Value2, ..., ValueN

OR

A

Number

Array

Series of number values.

Array containing numeric elements.

→ Result

Integer

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.

Parameter	Type	Description
`Value`	`Any`	Value to convert
`Default` (Optional)	`Number`	Optional. If provided and `Value` cannot be converted to a number, this function returns the `Default` rather than an error.
→ Result	`Number`	`Value` converted to a number.

Example:

NUMBER("1.234") → 1.234

POW

POW(B; E)

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

Parameter	Type	Description
`B`	`Number/Each`	Base
`E`	`Number`	Exponent
→ Result	`Number`	B to the power of E (B^E)

Example:

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

ROUND

ROUND(Value, N)

Rounds value to the N^th decimal place.

Parameter	Type	Description
`Value`	`Number/Each`	A number to round.
`N` (Optional)	`Integer`	How many decimal places to round to. Negative numbers round to the nearest tens, hundreds, etc. Default value: `0` (round to an integer).
→ Result	`Number`	`Value` rounded to the `N`^th 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).

Parameter	Type	Description
`Value`	`Number/Each`	Value to check.
→ Result	`Number`	Returns `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.

Parameter	Type	Description
`Value`	`Number/Each`	Numerical value.
→ Result	`Number`	`Value`²

Example:

SQR(5) → 25

SQRT

SQRT(Value)

Returns the square root of the passed numerical value.

Parameter	Type	Description
`Value`	`Number/Each`	Numerical value.
→ Result	`Number`	√`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.

Parameter

Type

Description

Number1, Number2, ..., NumberN)

OR

A

Number

Array

Array containing numeric elements.

→ Result

Integer

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

[data-colorid=d8dls83b0m]{color:#1d1c1d} html[data-color-mode=dark] [data-colorid=d8dls83b0m]{color:#e3e2e3}ABS

CEILING

FLOOR

LN

LOG

LOG10

MOD

MUL

NUMBER

POW

ROUND

SIGN

SQR

SQRT

SUM

ABS