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 Nth 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
EXP
EXP(x)
Calculates e to the power of 'x'.
Parameter | Type | Description |
---|---|---|
x | Number | Exponent |
→ Result | Number | e to the power of 'x' (ex) |
FLOOR
FLOOR(Value; N)
Rounds value down to the Nth 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 |
(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 |
---|---|---|
OR
|
| 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 (BE). Both values can be fractional.
Parameter | Type | Description |
---|---|---|
B | Number/Each | Base |
E | Number | Exponent |
→ Result | Number | B 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.
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 2 |
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 |
---|---|---|
OR
|
| 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