Versions Compared

Old Version 7

changes.mady.by.user João Brilhante

Saved on

compared with

New Version 8

changes.mady.by.user João Brilhante

Saved on

Key

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

This page describes the syntax to perform calculations.

Info

When writing calculation formulas, remember that they are evaluated on a per-requirement basis.

Info

If a property name contains space characters, you can escape them using a backslash \.

Arithmetic expressions

Syntax

Output

Description

Examples

number + number

number

Adds two numbers.

  • @Cost + ext@Taxes

  • @Width + 2.5

number - number

number

Subtracts a number from another.

  • ext@Budget - ext@Spent

  • 150 - @Height

number * number

number

Multiplies two numbers.

  • ext@Estimate * @Cost

  • 1.2 * @Cost

number / number

number

Divides a number by another.

  • @Width / @Height

  • @Cost / 0.75

number % number

number

Computes the remainder of the division between two numbers.

  • @Length % ext@Segment

  • ext@Man\ days % 10

...

Syntax

Output

Description

Examples

NOT boolean

boolean

Applies a logical NOT to a boolean expression.

  • NOT ext@Delivered

  • NOT (@Approved AND ext@Delivered)

boolean AND boolean

boolean

Applies a logical AND between two boolean expressions.

  • @Tested AND true

  • false AND true

boolean OR boolean

boolean

Applies a logical OR between two boolean expressions.

  • ext@Approved OR true

  • false OR true

  • expression = expression

  • expression == expression

boolean

Indicates whether two expressions are equal.

  • @Priority = 1

  • ext@Estimate * 1.4 2 * @Cost == 20500

  • @Author = ‘John Doe’

  • expression != expression

  • expression <> expression

boolean

Indicates whether two expressions are different.

  • @Priority != 5

  • @Width * 2 <> 120

number > number

boolean

Indicates whether a numeric expression is greater than another.

  • @Cost > 500

  • 1.2 * @Cost > ext@Budget

number >= number

boolean

Indicates whether a numeric expression is greater or equal to another.

  • @Cost >= 100

  • ext@Estimate + 10 >= 25

number < number

boolean

Indicates whether a numeric expression is less than another.

  • @Cost < 1000

  • ext@Man\ days < 30

number <= number

boolean

Indicates whether a numeric expression is less or equal to another.

  • @Width > 6.5

  • ext@Estimate <= 20

  • string ~ string

  • string LIKE string

  • string ILIKE string

boolean

Indicates whether a string expression matches a string pattern.

  • text ~ ‘%important%’

  • @Author ~ ‘John%’

  • @Tags LIKE ‘%Billing%’

expression IS NULL

boolean

Indicates whether an expression is null.

  • @Cost IS NULL

  • ext@Delivered IS NULL

expression IS NOT NULL

boolean

Indicates whether an expression is not null.

  • @Priority IS NOT NULL

  • ext@Estimate IS NOT NULL