Search code examples
nullssasmdx

MDX Operation, Syntax correct, Values = NULL

I Need to do the following calculation in mdx (i hope the code is straightforward, if clarification is needed please tell)

([Orders].[Customer].CurrentMember, [Measures].[InvoiceAmount]) / (Root([Orders]), [Measures].[InvoiceAmount])

but all I'm getting is NULL values, can anybody see what is wrong?

Solution

  • my question has been answered, thanks to you all for your great help MDX Operation, Syntax correct, Values = NULL