Problem with Sum?
I am having a measure column. I am applying sum to that. But its showing wrong value in that.
So, I tried to use Running Sum to get the actual sum. And using Max(RunningSum). Its giving the actual total value.
It solved my problem.
But, I observed that, there are some negative values coming. So, in the total value place, its showing the maximum of (RunningSum). But its not showing the sum with negative values.
Could any one help me, in solving this issue.