Sum(Descendants) in MDX Part II

Tue, 28 Jun 2011 02:31:38 GMT

Dear

sum({<#Equipment = {">0"}>}SalesAmount) / sum(#Equipement)

Sum(if(#Equipment >0, SalesAmount,0)) / Sum(#Equipment)

Both of them, give me the same result but it is not what I want. This is becasue there is two records of customer 1004.

In SQL Analysis Services, I can get the answer by using this MDX.

sum(Descendants([Customer].CurrentMember,[Customer].Customer),

(iif ([Measures].[#Equipment)] > 0, [Measures].[SalesAmount] / , 0))) / [Measures].[#Equipment]

Please advise.

Best Regards,

Anote

kaushiknsolanki — Tue, 28 Jun 2011 06:48:08 GMT

Hi,

Please refer to the post.

Regards,

Kaushik Solanki

topic Sum(Descendants) in MDX Part II in QlikView