+

Addition

12 + Quantity

-

Subtraction

15 - Rating

*

Multiplication

Result * Factor

/

Division

"Write off percentage" / 100

^

Potentiation: Raises the first value to the power of the second, e. g. 2⁸

2 ^ 8

%

Percentage: As on a calculator, you can add or subtract a percentage to/from a value.

Price - 10%

round(number, decimals)

Rounds the passed value to the specified number of significant decimal digits.

• round(15.386, 2) = 15.39

• round(15.5, 0) = 16

floor(number)

Rounds the passed value to the nearest lower integer.

• floor(16.34) = 16

ceiling(number)

Rounds the passed value to the nearest higher integer.

• ceiling(16.34) = 17

abs(number)

Gives the absolute value, i. e. the positive value.

• abs(-15) = 15

• abs(15) = 15

signum(number)

Normalises negative values to -1, zero to 0, and positive values to 1.

• signum(-255) = -1

• signum(0) = 0

• signum(135) = 1

mod(dividend, divisor)

Calculates the remainder of the dividend when divided by the divisor.

• mod(13, 2) = 1

Aggregating Function

Description

Example

sum(number…)

Sum of the passed values

• sum(1, 4, 5) = 10

avg(number…)

Average of the passed values

• avg(3, 5, 7) = 5

min(number…)

Smallest of the passed values

• min(-12, 0, 346) = -12

max(number…)

Largest of the passed values

• max(-135, 0, 1) = 1

Relation Function

Description

Example

subtasks(field)

Retrieves the values of the passed field from all subtasks.

• avg(subtasks("Story Points"))

parent(field)

Retrieves the values of the passed field from the parent of a subtask.

• parent("Quantity")

issuesInEpic(field)

Retrieves the values of the passed field from all issues in an epic.

• min(issuesInEpic("Budget"))

epic(field)

Retrieves the values of the passed field from the epic of an issue.

• epic("Price")

linkedIssues(linkName, field)

Retrieves the values of the passed field from all linked issues.

• max(linkedIssues('causes', "Percentage"))