I have a view in project database categorised by system, then status. The problem is that the same status category shows up twice:
Now, I have double-checked the contents of the status field and they are exactly the same in the documents in both categories:
Field Name: TaskCurrentStatus
Data Type: Text
Data Length: 9 bytes
Seq Num: 20
Dup Item ID: 0
Field Flags: SUMMARY
Of course, there can be a difference in Seq Num, but otherwise exactly the same.
Can anybody please help me understand why it is that they are in two different categories?