How do I stop a report showing two names, when only one name should appear?
I have a column titled 'Assigned To' and is only set to only allow one contact per cell.
When I run a report and use Group By 'Assigned To' it rolls together some cells which shouldn't be rolled together.
Weirder still, if I use the alternate sort order, another two names combine...
Note: I am using a =PARENT() calculation to autofill the CHILD cells, but still can't see why I would be getting two names in report generated, everything else is processed accurately.
Any ideas what this might be happening?