Case ELSE showing blank instead of the assigned value.

Some background info:

The main data source for my cross table is table1, and the Vertical axis is a unique list of item numbers.

For a given item number in Table 1, it may be recorded in Table2 anywhere from 0 of 5 details to all 5 details.

If it is entered for detail 5, it can be assumed that it sould be entered for details 1-4, etc.

It may be entered more than once for a given detail.

 

I'm trying to use this custom expression:

Case 
When Count(If([Table2].[Category]="Detail 5",1,null))>0 Then "Category 5"
When Count(If([Table2].[Category]="Detail 4",1,null))>0 Then "Category 4"
When Count(If([Table2].[Category]="Detail 3",1,null))>0 then "Category 3"
When Count(If([Table2].[Category]="Detail 2",1,null))>0 then "Category 2"
When Count(If([Table2].[Category]="Detail 1",1,null))>0 then "Category 1"
ELSE "Category 0"
END

 

In my final crosstable, I'm getting all of the categories to work except for Category 0. I'm just getting a blank result. I think this is because my main data table (Table1) is the main asset table with items that are not in Table2 and some error is occuring.

 

Any ideas would be great!

 

-Robert

Login