Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Please refer to the post.
http://community.qlik.com/message/127972#127972
Regards,
Kaushik Solanki
Hi,
Please refer to the post.
http://community.qlik.com/message/127972#127972
Regards,
Kaushik Solanki