Forum Discussion

MSuser5's avatar
MSuser5
Helper III
2 years ago
Solved

MDX Query

Hi Team,   I would like to calculate sum of value by excluding 'null' values in the column, I have tried in SSAS cube-new MDX as like below but the sum result is wrong instead of 9845  result is : ...
Need Help
  • MSuser5's avatar
    MSuser5
    2 years ago

    Thanks cpwebb ,

     

    I have used SUM(coalesceEmpty([Measure].[waitTimeInSec],0)) and it's working fine.

cpwebb's avatar
cpwebb
Microsoft Employee
2 years ago

I don't think the nulls are the problem - I don't see how they would result in a negative value here. What type of aggregation is your waitTimeInSec measure using? As I said, if you have already built a measure then writing something like sum([Measures].[Wait Time In Sec])  is redundant and [Measures].[Wait Time In Sec] should give you the same incorrect result.

MSuser5's avatar
MSuser5
Helper III
2 years ago

Hi cpwebb ,

 

i too wondering about result eventhough [Wait Time In Sec] is int datatype and i created only one measure which is used sum function.

sum([Measures].[Wait Time In Sec])

 

Thanks,