Calculation Syntax

This page describes the syntax to perform calculations.

Arithmetic expressions

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

Syntax	Result	Description	Examples
COUNT(requirement_list)	number
SUM(numeric_expression, requirement_list)	number
AVG(numeric_expression, requirement_list)	number
MAX(numeric_expression, requirement_list)	number
MIN(numeric_expression, requirement_list)	number

Syntax	Result	Description	Examples
NOT boolean_expression	boolean
boolean_expression AND boolean_expression	boolean
boolean_expression OR boolean_expression	boolean
expression = expression expression == expression	boolean
expression != expression expression <> expression	boolean
numeric_expression > numeric_expression	boolean
numeric_expression >= numeric_expression	boolean
numeric_expression < numeric_expression	boolean
numeric_expression <= numeric_expression	boolean
string_expression like string_expression string_expression ~ string_expression	boolean
expression IS NULL	boolean
expression IS NOT NULL	boolean