Calculation Syntax

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.

numeric % number

number

Computes the remainder of the division between two numeric expressions.

SUM(number, requirements)

AVG(number, requirements)

MAX(number, requirements)

MIN(number, requirements)

NOT boolean

boolean

boolean AND boolean

boolean

boolean OR boolean

boolean

• expression = expression

• expression == expression

boolean

• expression != expression

• expression <> expression

boolean

number > number

boolean

number >= number

boolean

number < number

boolean

number <= number

boolean

• string like string

• string ~ string

boolean

expression IS NULL

boolean

expression IS NOT NULL

boolean