Change Column Comparison Options

You can modify the comparison value columns that you have added to a report.

When using comparison values in a report, the comparison and compared values do not necessarily display on the same row as the corresponding values in the other column. This is because a value isn't automatically returned in a comparison column if there are no records to return.

For example, if a report outputs numbers of incidents assigned to two staff members during the current week and previous week, but the top staff member listed in the report had no incidents assigned in the previous week, there will not be an entry for that staff member in the comparison value column. This results in the comparison value for the second staff member displaying on the first row of the report.

To prevent this, you can set comparison options to have the report output a zero for any rows that lack a value in a column. This results in the corresponding values lining up with one another.

1. Add a comparison value column to a report.
2. Click the Home tab.
3. Click Comparison and select Edit Comparison Match Columns.
4. Select the column(s) that define the corresponding values.
5. Move the selected column to the Comparison Match Columns panel by dragging the field or clicking the right arrow.
6. Click OK.