Maths

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

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

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

Mathematical operators

OperatorDescriptionExampleExample result
+Additive operator / Unary plus1 + 34
-Subtraction operator / Unary minus4 - 31
*Multiplication operator2 * 36
/Division operator6 / 41.5
%Remainder operator (Modulo)5 % 32
^Power Operators2 ^ 38

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.

OperatorDescriptionExampleExample result
=Equals2 = 21
==Equals2 == 10
!=Not equals2 != 11
<>Not equals2 <> 20
<Less than1 < 21
<=Less than or equal to1 <= 11
>Greater than1 > 20
>=Greater than or equal to1 >= 20
&&Boolean and1 && 00
||Boolean or1 || 01

Functions

Functions names are case insensitive.

FunctionDescription
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

ConstantDescription
eThe value of e, exact to 70 digits
PIThe value of PI, exact to 100 digits
TRUEThe value one
FALSEThe value zero
NULLThe null value
Last modified on Feb 18, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.