Numeric Functions | Tempo Help Center

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.

Parameter

Type

Description

Value1, Value2, ..., ValueN

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.

Parameter

Type

Description

Number1, Number2, ..., NumberN)

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