Download User's Guide

purposes. For example, you could use group field values to find the
percentage of the grand total contributed by each group. For instance,
you may want to know what percentage of the $2,300,000 U.S. sales figure
the Western Region generated.
HOW TO INSERT GROUP FIELD VALUES INTO FORMULAS
Group field values can be inserted into formulas in the same way you
inserted other fields:
●
via the Fields tree, or
●
by typing them in manually.
NOTE: Due to the syntax complexity of some group fields, it is
recommended that you enter group fields by selecting them from the
Fields tree instead of manually typing them in. See Formula syntax, Page
306.
Formula
comments
Formula comments are notes included with a formula to explain its
design and operation.
Comments do not print and they do not affect the formula, but they
appear in the Formula Editor. It is always a good idea to include
comments with complex formulas for other users of your reports,
especially those formulas that will be used again and again.
HOW TO INSERT COMMENTS INTO FORMULAS
Type your comments into the Formula text box in the Formula Editor. A
comment must be preceded by two slashes (//). The comment can be
above or below the formula, or it can even follow the formula on the same
line.
Any of the following three placements are acceptable:
//This is an acceptable
//position for a comment.
//Note that when you force the line break,
//you have to begin each new line
//with double slashes. These comments
//refer to the formula below.
If {orders.ORDER AMOUNT} in (100.00 to 250.00) Then
.10 * {orders.ORDER AMOUNT}
Else
0
//This is also an acceptable comment position
//for detailing the formula above.
Introduction to Formulas
305