Page Comparison

...

Arithmetic expressions

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

...

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

Syntax	ResultOutput	Description	Examples
NOT boolean_expression	boolean	Applies a logical NOT to a boolean _ expression.
boolean AND boolean_expression	boolean	boolean_expression OR boolean_expression	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	booleannumeric_expression > numeric_expression	Indicates whether two expressions are different.
number > number	boolean	Indicates whether a numeric _ expression is greater than another.
number >= numeric_expressionnumber	boolean	Indicates whether a numeric _expression < numeric_expressionexpression 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	boolean	string_expression like string_expression string_expression ~ string_expression	boolean	expression IS NULL	booleanis 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.