Literal Values

You can use constant values in your formulas. Their type is determined by their format.

Number

To use a number constant, just use the number itself, for example 12000 or 42.86.

String

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

Fields

You can use any custom field of type number, or text fields that contain a number. JSU converts texts that only consist of a number to a number type.

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

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.	`"Square length" ^ 2`
`%`	Percentage: As on a calculator, you can add or subtract a percentage to/from a value.	`Price - 10%`

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 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)` → `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 the passed values.	`sum(1, 4, 5)` → `10` \| `sum(subtasks('quantity'))`
avg(number…)	Gives the average of the passed values.	`avg(3, 5, 7)` → `5`
min(number…)	Gives the smallest of the passed values.	`min(-12, 0, 346)` → `-12`
max(number…)	Gives the largest of the passed values.	`max(-135, 0, 1)` → `1`
Linking Function	Description	Example
subtasks(field)	Retrieves the values of the passed field from all subtasks.	`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.	`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.	`linkedIssues('causes', ‘Percentage’)`

Calculated Field Formulas