robotsnoindex
robotsnoindex

The following smart values are available to insert and format numerical values when setting up a rule.

To use a math expression, you need to use {{#=}}:

{{#=}}{{issue.Invoice Amount}} * 1.2{{/}}

Numerical operations

You can perform numerical operations on (and between) smart values using the following smart values.

Abs

Returns the absolute value of a number. For example, the absolute value of -6 is 6. This is useful for finding and returning the difference between two custom fields, for example Projected grown and Actual growth.

Example:

Projected growth is off by {{issue.Projected growth.minus(issue.Actual growth).abs}}

Round

Returns a number rounded to the nearest whole number. For example, 1.6 is rounded to 2. 

Example:

{{issue.timetracking.timeSpentSeconds.divide(3600).round}}

Floor

Returns the lower value of a number. For example, 1.9 returns 1.

Example:

{{issue.timetracking.timeSpentSeconds.divide(3600).floor}}

Ceil

Returns the upper value of a number. For example, 1.1 returns 2.

Example:

{{issue.timetracking.timeSpentSeconds.divide(3600).ceil}}

Plus/Minus

Adds or subtracts one numerical smart value with another. For example, you could update the current story point estimate for an issue by adding a point for each subtask. 

{{issue.Story Points.plus(issue.subtasks.size)}}

Multiply

Multiplies one numerical smart value with another. For example, you could set the target date of an issue as + 3 days for each story point.

{{now.plusBusinessDays(issue.Story Points.multiply(3))}}

Divide

Divides one numerical smart value with another. For example, you could find the number of hours per person spent on an issue.

We spent {{issue.timetracking.timeSpentSeconds.divide(3600).divide(issue.Request participants.size)}} hours per person on this ticket

Numerical comparisons

The following smart values are used to compare a numerical smart value with a given number. These values return either true or false, and can be combined with #if to print more helpful text based on the outcome.

Greater than

  • Syntax: gt(value)

Takes a numerical smart value, and checks if it is greater than the value given. For example, you can check the number of votes an issue has received, and print the words "Popular issue" if it has more than 100 votes.

{{#if(issue.Votes.gt(100))}} Popular issue {{/}}

Greater than or equal to

  • Syntax: gte(value)

Takes a numerical smart value, and checks if it is greater than the value given. For example, you can check the number of votes an issue has received, and print the words "Popular issue" if it has 100 or more votes.

{{#if(issue.Votes.gte(100))}} Popular issue {{/}}

Equal to

  • Syntax: eq(value)

Takes a numerical smart value, and checks if it is equal to the value given. For example, you can check that only one person is involved in a ticket, and print a message if this is the case.

{{#if(issue.Request Participants.size().eq(1))}} Only one person involved {{/}}

Less than

  • Syntax: lt(value)

Takes a numerical smart value, and checks if it is less than the value given. For example, you can check if a multi-value custom field has fewer than 2 options selected.

{{#if(issue.Multi Select custom field.size().lt(2))}} Only one option selected {{/}}

Less than or equal to

  • Syntax: lte(value)

Takes a numerical smart value, and checks if it is less than or equal to the value given. For example, you can check if a multi-value custom field has 2 or fewer options selected.

{{#if(issue.Multi Select custom field.size().lte(2))}} Too few options selected {{/}}

Format numerical values

format

Formats a number in US locale. For example, 123412345 becomes 123,412,345.

{{issue.Invoice Amount.format}}

format(input)

Formats a number in the given locale. Learn more about numeric print outputs at the Java documentation.

{{issue.Invoice Amount.format("###")}}

formatWithLocale(input)

Formats a number in the given locale. Eg, for "fr_FR", 123412345 becomes 123 412 345. For a list of locales, refer to the Java documentation.

{{issue.Invoice Amount.formatWithLocale("fr_FR")}}

asPercentage

Formats a number as a percentage in the US locale. For example, 0.123 became 12%. 

{{issue.Story Points.asPercentage}}

asPercentage(locale)

Formats a number as a percentage in the given localeFor a list of locales, refer to the Java documentation.

{{issue.Story Points.asPercentage("fr_FR")}}

asCurrency

Formats a number as a currency in the US locale. For example, 0.123 becomes $0.12.

{{issue.Invoice Amount.asCurrency}}

asCurrency(locale)

Formats a number as a currency in the given locale. For example, for "fr_FR", 0.123 becomes 0,12€. For a list of locales, refer to the Java documentation.

{{issue.Invoice Amount.asCurrency("fr_FR")}}

Mathematical operators

Operator

Description

Example

Example result

+

Additive operator / Unary plus

1 + 3

4

Subtraction operator / Unary minus

4 - 3

1

Multiplication operator

2 * 3

6

/

Division operator

6 / 4

1.5

%

Remainder operator (Modulo)

5 % 3

2

^

Power Operators

2 ^ 3

8

Boolean operators

Boolean operators always result in a value of 1 or 0 (zero). Any non-zero value is treated as a true value. Boolean not is implemented by a function.

Operator

Description

Example

Example result

=

Equals

2 = 2

1

==

Equals

2 == 1

0

!=

Not equals

2 != 1

1

<>

Not equals

2 <> 2

0

<

Less than

1 < 2

1

<=

Less than or equal to

1 <= 1

1

>

Greater than

1 > 2

0

>=

Greater than or equal to

1 >= 2

0

&&

Boolean and

1 && 0

0

||

Boolean or

1 || 0

1

Functions

Functions names are case insensitive.

Function

Description

NOT(expression)

Boolean negation, 1 (means true) if the expression is not zero.

IF(condition,value_if_true,value_if_false)

Returns one value if the condition evaluates to true or the other if it evaluates to false.

RANDOM()

Produces a random number between 0 and 1.

MIN(e1,e2...)

Returns the smallest of the given expressions.

MAX(e1,e2...)

Returns the biggest of the given expressions.

ABS(expression)

Returns the absolute (non-negative) value of the expression.

ROUND(expression,precision)

Rounds a value to a certain number of digits, uses the current rounding mode; helpful with formatting numbers.

FLOOR(expression)

Rounds the value down to the nearest integer.

CEILING(expression)

Rounds the value up to the nearest integer.

LOG(expression)

Returns the natural logarithm (base e) of an expression.

LOG10(expression)

Returns the common logarithm (base 10) of an expression.

SQRT(expression)

Returns the square root of an expression.

SIN(expression)

Returns the trigonometric sine of an angle (in degrees).

COS(expression)

Returns the trigonometric cosine of an angle (in degrees).

TAN(expression)

Returns the trigonometric tangents of an angle (in degrees).

ASIN(expression)

Returns the angle of asin (in degrees).

ACOS(expression)

Returns the angle of acos (in degrees).

ATAN(expression)

Returns the angle of atan (in degrees).

SINH(expression)

Returns the hyperbolic sine of a value.

COSH(expression)

Returns the hyperbolic cosine of a value.

TANH(expression)

Returns the hyperbolic tangents of a value.

RAD(expression)

Converts an angle measured in degrees to an approximately equivalent angle measured in radians.

DEG(expression)

Converts an angle measured in radians to an approximately equivalent angle measured in degrees.

Constants

Constant

Description

e

The value of e, exact to 70 digits.

PI

The value of PI, exact to 100 digits.

TRUE

The value one.

FALSE

The value zero.

NULL

The null value.