CODEWITHSUNDEEP
sqlvisual-studiossasmdxcube
Keag1
Keag1

Reputation: 141

MDX SUM function returning true

I am trying to do a simple sum of 2 measures in MDX.

my query looks like this 

[Measures].[Submissions Count] = SUM({[Measures].[Gain Count] , [Measures].[No Movement Count]}, [Measures].[Submissions Count])

when i brows the cube in visual studio the result displays 'True'. It should be a numeric value

Upvotes: 0

Views: 85

Answers (1)

whytheq
whytheq

Reputation: 35557

Can you not just use the + operator?

[Measures].[Submissions Count] = 
  [Measures].[Gain Count] + [Measures].[No Movement Count];

Upvotes: 1

Related Questions