Why does the Assigned value in a workspace not match the value in a report?

Environment:

All sites, Reporting, Workspaces.

Issue:

Incidents' assigned account ID does not match in both your workspace and a report.

Cause:

In an incident workspace, the Incidents.Assigned field typically shows the value of incidents.assgn_acct_id. However, if incidents.assgn_acct_id is null (has no value), then the workspace will show you the value of incidents.assgn_group_id instead.

Resolution:

You can force a report to match the workspace. To force the report to match the workspace, you will need to replace the column definition incidents.assgn_acct_id with the following:

       IF(incidents.assgn_acct_id IS NULL, incidents.assgn_group_id, incidents.assgn_acct_id)