Categorized view not working correcly. What am I doing wrong?

Hi there!

I have the following formula for a categorized column in a view:

Onsite:

StorageLocation1:

StorageLocation2:

StorageLocation3:

StorageLocation4:

DeductLocation

When I display the view, all of the categories are displayed, but at the bottom I have one (Not Categorized) and in this column are all of the documents that are already displayed in their appropriate categories.

Any ideas why this is happening? Weird, huh?

Gérald

Subject: Categorized view showing unexpected (Not Categorized) category

Try to @Trim your formula:

@Trim(Onsite: StorageLocation1: StorageLocation2: StorageLocation3: StorageLocation4: DeductLocation)

Hope this helps,

Stephan

Subject: RE: Categorized view showing unexpected (Not Categorized) category

Wow! Now that was easy! Wish they were all like this!

Thanks, Stephan.

:wink:

Gérald

Subject: RE: Categorized view showing unexpected (Not Categorized) category

Also, unless you are sure that every document has alt least one of your locations non-blank, you may want to add the followint to the view’s selection formula:

!(@Trim(Onsite:

StorageLocation1:

StorageLocation2:

StorageLocation3:

StorageLocation4:

DeductLocation) = “”)