# Maths

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

:

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

## 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 |

Last modified on Feb 18, 2020

Powered by Confluence and Scroll Viewport.