Elements of a property expression

Property expressions are composed of one or more elements that will supply values at runtime.

The following elements make up property expressions:

  • Functions: Examples of functions include mathematical or statistical operations such as Min() and StdDev(). You can use functions to calculate values, convert values, or to specify Boolean conditions.
  • Operators: Examples of operators include =, >, and <. You can use operators to perform arithmetic, to compare values, or to concatenate values.
  • Column Names: Examples of column names might be any name that has been assigned to a column of data returned by a query. You can use these column names in your expressions.
  • Formatting symbols: Examples of formatting symbols are $, #, and %. You can use these symbols to format numeric and date/time values.
  • Constants: Examples of constants are values for any valid data type, such as True and False for a Boolean data type. Use constants in functions, with operators, with column names, and by themselves to specify a property value of the appropriate data type.