Link to home
Start Free TrialLog in
Avatar of kasperEH
kasperEHFlag for Denmark

asked on

Same category shows up twice in view

I have a view in project database categorised by system, then status. The problem is that the same status category shows up twice:
 User generated imageNow, 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

"Completed"

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?
ASKER CERTIFIED SOLUTION
Avatar of CRAK
CRAK
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Could be, indeed... Not only Date/Time, but any sorted column could do this.

My other option: could there be an extra space or other character in one of the Completed categories... Always use @Trim(@ThisValue) as +Input Translation formula.
Avatar of kasperEH

ASKER

Thank you, CRAK. I solved the problem by removing a hidden column.
Thanks also to sjef bosman for commenting.