User`s guide

Description of contentsWindow
Functions are prebuilt procedures that return val-
ues. They perform calculations such as average,
sum, count, sin, trim, and uppercase.
Custom functions are also listed in this window.
Functions
Operators are the "action verbs" you use in formu-
las. They describe an operation or an action to
take place between two or more values.
Examples of operators: add, subtract, less than,
and greater than.
Operators
Area where you create a formula.Formula text window
20.4.2.2 Choosing the syntax
The Expressions Editor Toolbar of the Formula Workshop contains the drop-down list where you choose
either Crystal or Basic syntax for the formula you are creating.
Note:
Changing the syntax from Crystal syntax to Basic syntax or vice versa will change the list of functions
in the Functions window as well as the list of operators in the Operators window. The functions and
operators differ from syntax to syntax.
The available report fields remain the same since the report fields are available to each syntax.
Setting the default syntax
When you open the Formula Editor, Crystal syntax appears as the syntax default. If you want to change
the syntax default, select Options from the File menu, then click the Reporting tab. Choose the preferred
syntax from the Formula Language drop-down list and click OK. When you access the Formula Editor,
the syntax you selected appears as the default.
20.4.2.3 Entering formula components
2012-03-14425
Using Formulas