Using the Formula Editor

Important: The Report Designer interface has changed. Report Designer documentation has been updated to reflect recent changes.

You can associated The Formula Editor allows you to associate a formula with a text fieldsfield, date fieldsfield, number fieldsfield, and so on. For example
Image Removed
 
. Formulas allow you to define relationships between columns in your report. While formulas serve an important role, they can be difficult to create. The Formula Editor makes the process of creating formula easy and efficient; it also validates the formula thereby minimizing errors. Follow the instructions below to create a formula:

1. In the Design pane, select a field to which you will associate a formula.
2. In the Properties panel, click Formula to open the Formula Editor.
3. In the Format Editor dialog box, select a Category from the list.  The Function list is populated with the functions that are most appropriate for the category you selected.
4. Select the appropriate function. When you select a function, the Report Editor displays the formula expression (the equation that includes parameters); it also displays the Return Type and Description as shown in the example below:
    
   Image Added

Formula Syntax Description

...

Userdefined
NULL - Returns a NULL-Value

Formula Operators

...

+ Add
- Subtract
* Multiply
/ Divide
= Equal
<> Not Equal
< Less Than
> Greater Than
<= Equal Less Than
>= Equal Greater Than
& Concatenate
^ Power

...