Calculations can be used as columns in a report for special summaries based on the values of the report data. These calculations are performed dynamically when the report is rendered.
To add a calculated column to a report:
- Go to Report Builder.
- In the Relationship viewer pane, select Calculated icon. The Calculation dialogue appears.
- Type a name for the calculation in the Column Name field.
- Type the calculation in the Enter Calculation field.
- Select OK.
- Select SAVE to save the report. The data displays in view mode of the report.