I have a cube with multiple cacluated members that allows
the user to view the measure (dollar amount) by different
categories. Usually the members are straightforward -
simply based on a specific value in a field i.e. FieldA =
123.

My scenario is if FieldA is valued with '-' which is our
default for spaces, I want to extend my search to other
dimensions. My current MDX is:

[Detail_Pos_1_and_4_IBC].[Detail Code Position 1].&[A]+

SUM({[Detail_Pos_1_and_4].[Detail Code Position 1].&[-]},
([Cred_Code_ABC].[Cred Code].&[P],[Control_Code_ABC].
[Control Code].&[C62]))

This pulls in all recs with detail code A plus all recs
with detail code '-' where cred code is P and control code
is C62. This works great and I balance exactly. My
problem is I need to build another calculated member
exactly as above except I want all control codes BUT C62.
I've tried to play with the EXCEPT command but am getting
all kinds of syntax errors.

Any suggestions?

Thanks,
Jim