Add a Comparison Percentage Column to a Report

After adding a comparison value column to a report for a numeric field, you can then add a Comparison Percentage computed field column to the report.

Before you start

Before adding a comparison percentage column, you must first add a comparison value column to the report. See Add a Comparison Value Column to a Report.

This column returns the percentage difference between the comparison value column and the column being compared. For example, if a value in the compared column is 10, and the corresponding comparison value is 15, the percentage difference would be 50%.

Here's what to do

1. Expand the Computed Fields tree in the data dictionary.
   Tip: You can also add comparison percentage columns by clicking the comparison column you added on the design surface, clicking the Design tab, clicking the arrow on the Insert Column button, and then selecting Comparison % Change.
2. Click the comparison value column you added.
3. From the right side of the data dictionary, drag the Comparison Percentage column name and drop it on the design surface.
4. To set options for the column, right-click the column on the design surface and select Edit Comparison Percentage Options.
   Tip: You can also adjust options by selecting the column and using the buttons on the Design tab’s % Change group.
5. Enter field information.

   Comparison Percentage Options Window

   Field	Description
   Comparison Direction	Select whether the comparison column or the compared column is used as the initial column to derive the comparison percentage.
   Comparison Data to Report Data	Select this option to use the comparison value column as the initial column to derive the comparison percentage. If the value in the comparison value column is greater than the corresponding value in the compared column, a positive percentage is returned.
   Report Data to Comparison Data	Select this option to use the compared column as the initial column to derive the comparison percentage. If the value in the compared column is greater than the corresponding value in the comparison value column, a positive percentage is returned.
   Display Change Icon	Select this check box to display icons next to the percentage values returned in the column. The icons show you if there’s a positive change, negative change, or no change. To change the colors used for the icons, click the icon to open the Color window. See Change Colors.

6. Click OK.