Same category shows up twice in view

Posted on 2011-10-11
Last Modified: 2013-12-18
I have a view in project database categorised by system, then status. The problem is that the same status category shows up twice:
 screenshotNow, 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?
Question by:kasperEH
    LVL 13

    Accepted Solution

    Is there a hidden column left of the TaskCurrentStatus-column that could cause this?
    E.g. Date/Time columns may sometimes cause this kind of behaviour.
    LVL 46

    Expert Comment

    by:Sjef Bosman
    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.

    Author Closing Comment

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

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now