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