The Elements of an Expression

Fixed text, variables, formulae, functions, operators and the like – generally referred to below as "Elements of expressions" – are all inserted and combined by means of a common dialog.

The formula wizard helps you with your entries in several ways:

* Function syntax display: A tooltip appears describing the chosen function; it lists the required parameters and shows the result type.

* Auto complete: When you type a letter, the available functions, fields and variables are listed that begin with this letter. Within functions, suitable values are suggested for parameters.

* Syntax coloring: Functions, parameters, operators and comments are shown in different colors.

* Automatic type conversion: Variable and field types are converted automatically when inserted in existing expressions to ensure that the data type corresponds to that expected.

Figure 10.3: Autocomplete in the formula wizard