Formulas

(This section relates to users with an Enterprise Licence only)

Formulas are equations that can be used to perform calculations, manipulate characters and dates, return information, or test data. A formula can contain any or all of the following: fields, constants (numbers, text, dates), operators, and functions. In Designer Studio you can create formulas in the Formula Designer.

In this section:

• Formula Designer
• Parts of a formula
• Create a formula
• Add fields to a formula
• Add constants to a formula
• Add operators to a formula
• Add functions to a formula
• Using operators
• Formula properties
• Round a number
• Test a formula
• Open and edit a formula