Formula Bar

Definition

The Formula Bar shows the contents of cells in your report. It can also be used to enter new information, especially formulas, without the use of a variable. The formula editor makes building and changing formulas in the formula bar much easier. This can be useful as a quick way to complete the same thing, but it can only be used in the one field and can't be transferred to other fields or tables or used in other variables.

This guide shows how to use the formula bar and get to the formula editor; for more information about the formulas themselves, check out our Formula Guides in the Variables section.

Video

Formula Bar and Editor

Prerequisite: Have your report open and make sure it is in Design Mode. If necessary, refresh your report.

Formula Bar

The formula bar is located above your report and below the report-design menus.

Screenshot of InfoView showing location of the formula bar

If you do not see this bar already after switching into design mode, complete the following:

1. Navigate to the menu Analysis.

Screenshot of InfoView showing location of formula bar button

2. Click on the right-most button with the "fx" symbol on it.

The bar should appear and the button should highlight in blue.

Formula Editor

The formula editor can be opened by selecting a cell and clicking the first button on the formula bar.

Screenshot of InfoView formula bar showing location of formula editor button

The formula editor is the same panel as the create or edit variable panel, but missing the details that define the formula as an object (name, qualification, etc.). Besides this, the formula panel acts in exactly the same way.

Screenshot of InfoView Formula Editor panel

For more information about the formulas themselves and the formula panel, check out our Formula Guides in the Variables section.