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.2: Autocomplete in the formula wizard
See also: