| Table of Contents | ||
|---|---|---|
|
Formulas
Formulas are constructed by stringing together operators, values and functions in a way that a single value results from them. Literal values, fields, and mathematical functions all result in one value, while linking functions can result in multiple values, depending on the number of issues that are involved. Operators or aggregating functions reduce multiple values into one. A formula must result in a single value, so subtasks('Quantity') is invalid, but sum(subtasks('Quantity')) is valid.
Literal Values
You can use constant values in your formulas. Their type is determined by their format.
...
Operator | Description | Example |
|---|---|---|
| Addition: Adds the two values. |
|
| Subtraction: Subtracts the second value from the first. |
|
| Multiplication: Multiplies the two values. |
|
| Division: Divides the first by the second value. |
|
| Potentiation: Raises the first value to the power of the second. |
|
| Percentage: As on a calculator, you can add or subtract a percentage to/from a value. |
|
Grouping – Parentheses
Parentheses can be used to group operations to override operator precedence. 2 * 3 + 3 equals 9, but 2 * (3 + 3) equals 12.
Functions
Functions are versatile, we provide three types of them. One type consists of mathematical functions, to enable more calculations you can do. The second are aggregating functions, where you combine multiple values into one. The third type fetches values from other related issues.
Mathematical functions and aggregating functions can handle the multiple values returned by the linking functions subtasks, issuesInEpic, and linkedIssues, but only the aggregating functions reduce them to a single value. The mathematical functions apply themselves to each value in the list and return a list of equal size.
Mathematical Function | Description | Example | Can Take Multiple Values | Returns Multiple Values |
|---|---|---|---|---|
round(number, decimals) | Rounds the passed value to the specified number of significant decimal digits. |
|
|
|
floor(number) | Rounds the passed value to the nearest lower integer. |
|
|
|
ceiling(number) | Rounds the passed value to the nearest higher integer. |
|
|
|
abs(number) | Gives the absolute value, i. e. the positive value. |
|
|
|
signum(number) | Normalises negative values to -1, zero to 0, and positive values to 1 |
|
|
|
mod(dividend, divisor) | Calculates the remainder of the dividend when divided by the divisor. |
|
|
|
Aggregating Function | Description | Example | Can Take Multiple Values | Returns Multiple Values |
sum(number…) | Sums up the passed values. |
|
|
|
avg(number…) | Gives the average of the passed values. |
|
|
|
min(number…) | Gives the smallest of the passed values. |
|
|
|
max(number…) | Gives the largest of the passed values. |
|
|
|
Linking Function | Description | Example | Can Take Multiple Values | Returns Multiple Values |
subtasks(field) | Retrieves the values of the passed field from all subtasks. |
|
|
|
parent(field) | Retrieves the values of the passed field from the parent of a subtask. |
|
|
|
issuesInEpic(field) | Retrieves the values of the passed field from all issues in an epic. |
|
|
|
epic(field) | Retrieves the values of the passed field from the epic of an issue. |
|
|
|
linkedIssues(linkName, field) | Retrieves the values of the passed field from all linked issues. |
|
|
|
