How to: |
You can perform calculations on data in an active report. Types of calculations that you can apply are:
For numeric fields, you can also apply:
Calculations are applied to the entire data set and to the filtered and/or expanded data in the report. What this means is that reports that have filters applied, or are not fully expanded, will have multiple results appear for calculations. The first is the calculation for the visible data (that is the data that currently appears in the report output). The second is the result for all values in the report even if they are filtered out or are not currently showing in an expandable report.
All calculations appear in the top or bottom row of a report, except the % of Total calculation. The % of Total calculation appears in a new column to the right of the selected column.
When a filter is applied, you can toggle between different displays of calculated data. Calculations are not recalculated on page breaks. Some calculations may initially appear in your report. You can change these.
Calculations on data in the Scientific Notation format are not supported.
The following image shows a filtered report in which the Sum calculation for Quantity appears in the top row and the % of Total calculation appears in a new column to the right of the selected column, Line Total.
Click the arrow in the heading of the column you want to calculate, click Calculate and then the operation.
Calculation results appear in the top or bottom row of the report, depending on how the report is designed.
Click the arrow in the heading of the column where you want to clear calculations. Select Calculate, then Clear (to clear the calculation for the individual column) or Clear All (to clear all calculations).
Recompute recalculates values only at the specified sort break.
The recomputed field appears in the Report Painter window, indicated by the word *TOTAL.
The following image is an example of an HTML active report (AHTML) with Rating as the RECOMPUTE field.
Summarize recalculates values at all outer sort breaks.
The recomputed field appears in the Report Painter window, indicated by the word *TOTAL.
The following image is an example of an HTML active report (AHTML) with Rating as the Summarized field.
WebFOCUS |