Calculation Syntax

This page describes the syntax to perform calculations.

Arithmetic expressions

Syntax	Output	Description	Examples
number + number	number	Adds two numeric expressions.	@Width + @Height ext@Cost + 10
number - number	number	Subtracts a numeric expression from another.	@Width - 1.5 150 - ext@Cost
number * number	number	Multiplies two numeric expressions.	@Width * @Height ext@Estimate * 1.2
number / number	number	Divides a numeric expression by another.
number % number	number	Computes the remainder of the division between two numeric expressions.

Syntax	Output	Description
COUNT(requirements: requirement[])	number	Counts requirements.
SUM(expression: number, requirements: requirement[])	number	Computes the sum of a numeric expression applied to a list of requirements.
AVG(expression: number, requirements: requirement[])	number	Computes the average of a numeric expression applied to a list of requirements.
MAX(expression: number, requirements: requirement[])	number	Computes the maximum value of a numeric expression applied to a list of requirements.
MIN(expression: number, requirements: requirement[])	number	Computes the minimum value of a numeric expression applied to a list of requirements.

Syntax	Output	Description
NOT boolean	boolean	Applies a logical NOT to a boolean expression.
boolean AND boolean	boolean	Applies a logical AND between two boolean expressions.
boolean OR boolean	boolean	Applies a logical OR between two boolean expressions.
expression = expression expression == expression	boolean	Indicates whether two expressions are equal.
expression != expression expression <> expression	boolean	Indicates whether two expressions are different.
number > number	boolean	Indicates whether a numeric expression is greater than another.
number >= number	boolean	Indicates whether a numeric expression is greater or equal to another.
number < number	boolean	Indicates whether a numeric expression is less than another.
number <= number	boolean	Indicates whether a numeric expression is less or equal to another.
string like string string ~ string	boolean	Indicates whether a string expression matches a string pattern.
expression IS NULL	boolean	Indicates whether an expression is null.
expression IS NOT NULL	boolean	Indicates whether an expression is not null.