Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page describes the syntax to perform calculations.

Arithmetic expressions

Syntax

Result

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.

numeric % number

number

Computes the remainder of the division between two numeric expressions.

Aggregation expressions

Syntax

Result

Description

Examples

SUM(number, requirements)

AVG(number, requirements)

MAX(number, requirements)

MIN(number, requirements)

Boolean expressions

Syntax

Result

Description

Examples

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