Page Comparison

...

...

Anchor
abs abs

ABS

ABS(Value)

Calculates the absolute value of a number.

Examples:

• ABS(5) → 5

• ABS(-4) → 4

Anchor
ceiling ceiling

CEILING

...

Rounds value up to the N^th decimal place.

Examples:

• CEILING(1.678) → 2

• CEILING(12.34; 1) → 12.4

• CEILING(12.34; -1) → 20

• CEILING(-3.14) → -3

Anchor
floor floor

FLOOR

FLOOR(Value; N)

Rounds value down to the N^th decimal place.

Examples:

• FLOOR(1.678) → 1

• FLOOR(12.34; 1) → 12.3

• FLOOR(17.34; -1) → 10

• FLOOR(-3.14) → -4

Anchor
ln ln

LN

LN(x)

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

Anchor
log log

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

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"
)

...

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

Anchor
mod mod

MOD

MOD(A; N)

Returns the remainder from dividing A by N.

Example:

• MOD(17; 5) → 2

Anchor
mul mul

MUL

MUL(Value1, Value2,...)

...

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. 

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

Example:

• MUL(2, 3, 5) → 30

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

Anchor
number number

NUMBER

NUMBER(Value, DefaultOpt)

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

Example:

• NUMBER("1.234") → 1.234

Anchor
pow pow

POW

POW(B; E)

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

Example:

• POW(3; 3) → 27

• POW(27; 1/3) → 3

Anchor
round round

ROUND

ROUND(Value, N)

Rounds value to the N^th decimal 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)
  

Anchor
sign sign

SIGN

SIGN(Value)

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

Examples:

• SIGN(123) → 1

• SIGN(0) → 0

• SIGN(-123) → -1

Anchor
sqr sqr

SQR

SQR(Value)

Returns the passed numerical value, squared.

Example:

•  SQR(5) → 25

Anchor
sqrt sqrt

SQRT

SQRT(Value)

Returns the square root of the passed numerical value.

Example:

• SQRT(25) → 5

Anchor
sum sum

SUM

SUM(Number1, Number2, ...)

...

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.

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