MDX Except Function Error

Last Post 31 Aug 2004 04:41 AM by bigelectricmac. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bigelectricmac
New Member
New Member

--
31 Aug 2004 04:41 AM
I am trying create a calculated member that uses the Except() function, but I get and error that says, "Formula error - cannot convert set to Expression - in the Difference function".
Here is the MDX:

EXCEPT({[Prod Id Basket].CurrentMember,[Measures].[Basket Quantity]},{[Product ID].CurrentMember,[Measures].[Basket Quantity]})

To explain the formula" If the product ID number in Prod Id Basket is the same number in Product ID, then hide it.

Any insight would be appreciated...

TC
tclauer@badcock.com
You are not authorized to post a reply.

Acceptable Use Policy