Report Wizard: Group By Panel
The Group By panel specifies how results are grouped together in a report. Depending on the report type you selected, the Group By panel may contain multiple Group by level tabs.
For each tab, select a field from the Field list, and then select the sort order (Ascending or Descending).
If your report includes numeric fields, you can perform arithmetic calculations between one or more numeric fields and display the results in the report. For example, if your report currently displays a list of Project items, you could calculate the difference between the Actual Budget and Estimated Budget fields for each Project item and display the values in a new field called Over/Under Budget. The arithmetic calculation behind the Over/Under Budget is a computed expression.
To create a computed expression, click
Add (GUI) or
(Web). The
Add Expression dialog box displays. For more information, see
Add Expression or Edit Expression Dialog Box.
| To create a valid computed expression, the numeric fields used in the expression must be in the Selected list of the previous panel. |
To edit an existing computed expression, select it and click
Edit in the GUI, or
in the Web. The
Edit Expression dialog box displays. For more information, see
Add Expression or Edit Expression Dialog Box.
To remove a computed expression, select it, and click
Remove (GUI) or
(Web).