IF expression for dimension issue

[Anonymous]

Hello,

I'm having trouble with this IF expression for a dimension on a pivot table.

The last 2 columns are IF functions and are almost identical except the else expression.

The first IF statement correctly returns null but the second statement returns the else expression even though it meets the same condition expression as the first statement.

Is there an issue with the field I'm using in the else expression?  That field is used as an association on a concatenated table.

Thanks for help!

Rick

[Anonymous]

After searching around, I found i have to include 'nodistinct' within aggr.  I read the notes about nodistinct but I don't understand what it means.  Can someone help explain that?