Calculation Syntax

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@Section

• ext@Man\ days % 10

COUNT(requirements: requirement[])

number

Counts the requirements in a given list.

• COUNT(from@Refines)

• COUNT(to@Refines->from@Uses)

SUM(expression: number, requirements: requirement[])

number

Computes the sum of a numeric expression applied to a list of requirements.

• SUM(@Cost, from@Refines)

• SUM(ext@Estimate * @Cost, from@Refines)

• SUM(1.2 * @Cost, from@Refines->from@Uses)

AVG(expression: number, requirements: requirement[])

number

Computes the average of a numeric expression applied to a list of requirements.

• AVG(@PropertyA, from@Refines)

• AVG(@PropertyA, from@Refines->from@Uses)

• AVG(1.5 + @PropertyA, from@Refines)

MAX(expression: number, requirements: requirement[])

number

Computes the maximum value of a numeric expression applied to a list of requirements.

• MAX(@PropertyA, from@Refines)

• MAX(2.5 * @PropertyA, from@Refines)

• MAX(@PropertyA, from@Refines->from@Uses)

MIN(expression: number, requirements: requirement[])

number

Computes the minimum value of a numeric expression applied to a list of requirements.

• MIN(@PropertyA, from@Refines)

• MIN(@PropertyA - 15, from@Refines)

• MIN(@PropertyA, from@Refines->from@Uses)

relationship

requirement[]

Retrieves linked requirements (parent or child) for the current requirement.

• from

• to

• from@Refines

• to@Uses

• relationship->relationship

• relationship→relationship

requirement[]

Retrieves linked requirements (parent or child with multiple levels of depth) to the current requirement.

• to→from@Uses

• from@Refines→from@Uses

DISTINCT(requirements: requirement[])

requirement[]

Filters a list to keep only distinct requirements.

• DISTINCT(to→from@Uses)

• DISTINCT(from@Refines→from@Uses)

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.2 == 20

• @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.

• ext@Cost > 500

• @Cost + ext@Taxes > 1000

number >= number

boolean

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

• @Cost >= 0

• ext@Estimate - 10 >= 0

number < number

boolean

Indicates whether a numeric expression is less than another.

• @PropertyA < 0

number <= number

boolean

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

• @PropertyA <= 0

• string ~ string

• string LIKE string

• string ILIKE string

boolean

Indicates whether a string expression matches a string pattern.

• @Author ~ ‘John%’

expression IS NULL

boolean

Indicates whether an expression is null.

• @Cost IS NULL

expression IS NOT NULL

boolean

Indicates whether an expression is not null.

• @Cost IS NOT NULL

• ext@Delivered IS NOT NULL