Reference Guide

Building Reports Using the Web Intelligence Java Report Panel 311
The Formula Editor shows the report objects, functions and operators that you can use
to build a formula.
NOTE: To make your formula easier to read, you can use the Ctrl+Enter or
Alt+Enter keys to insert line breaks.
Building a formula using the Formula Editor
To build a formula, using the Formula Editor:
1. Select the cell on the report where you want to include the formula.
You can select a table cell or a free-standing cell.
2. Display the Formula toolbar and the Formula Editor.
See ”Displaying the Formula Editor” on page 310, above.
3. On the Data, Functions and Operators tabs, double-click the report objects,
functions and operators you want to include in the formula, or type the formula directly.
For example, to create the formula =
Average([Revenue]), double-click the Average()
function, then double-click the Revenue object.
NOTE: When you double-click a function to include it in a formula, Web
Intelligence places the cursor between the function parentheses.
Including text in cells
The text in report cells always begins with ‘=’ . Literal text appears in quotation marks,
while formulas appear without quotation marks. For example, the formula
Average([Revenue]) appears in a cell as:
=Average([Revenue])
The text “Average Revenue” appears as:
=”Average Revenue”
You can use text alone in a cell, or mix formulas and text by using the ‘+’ operator. If you
want a cell to display the average revenue preceded by the text “Average Revenue”, the
cell text is as follows:
=”Average Revenue: ” + Average([Revenue])
Note the space at the end of the text string so that the text and the value are not placed
directly side-by-side in the cell.
Saving formulas as variables
You can save a formula as a variable in order to re-use it throughout a report. For
information on how to do this, see ”Saving formulas as variables” on page 343.