# Page Comparison

## Key

• This line was removed.
• Formatting was changed.

...

To use a custom field, type its name, for example `Budget` or `Quantity`. If your field’s name contains spaces or special characters, you must surround it with double quotes, for example `“Story Points”`. Quotes are optional for values without spaces or special characters, e. g. `"Quantity"`.

# Operators

Operators combine two values. The following operators are supported:

Operator

Description

Example

`+`

`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. 28

`2 ^ 8`

`%`

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

`Price - 10%`

# Parentheses

Parentheses can be used to group operations to override operator precedence. `2 * 3 + 3` equals 9, but `2 * (3 + 3)` equals 12.

...

Info

Jira automatically rounds values to three decimal places. Be careful when you need exact results.

Mathematical Function

Description

Example

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

Must be aggregated before using outside of a function.

• `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.

Must be aggregated before using outside of a function.

• `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.

Must be aggregated before using outside of a function.

Note

The link type must be given in single quotes: `‘causes’`

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