Versions Compared

Old Version 4

changes.mady.by.user Benjamin Weber {Appfire}

Saved on

compared with

New Version 5

changes.mady.by.user Stefan Forstmoser

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You will need this for certain functions. Texts cannot be used to calculate something. To make a text value, use single quotes ‘, for example ‘this is a text’ or 'causes’.

...

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

Operators

Operators combine two values. The following operators are supported:

Operator

Description

Example

+

Addition: Adds the two values.

12 + Quantity

-

Subtraction: Subtracts the second value from the first.

15 - Rating

*

Multiplication: Multiplies the two values.

Result * Factor

/

Division: Divides the first by the second value.

"Write off percentage" / 100

^

Potentiation: Raises the first value to the power of the second, e. g. "Square length" ^ 228

2 ^ 8

%

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

Price - 10%

...

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…)

Sums up Sum of the passed values.

  • sum(1, 4, 5) = 10sum(subtasks('quantity'))

avg(number…)

Gives the average Average of the passed values.

  • avg(3, 5, 7) = 5

min(number…)

Gives the smallest Smallest of the passed values.

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

max(number…)

Gives the largest 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'))

  • sum(round(subtasks('Price', 0)))

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.

  • max(linkedIssues('causes', ‘Percentage’))

Advanced