Forum Discussion
Solved
Adding two measure totals from the same table
Dear all, I’m desperately looking for advise on how to add two separate calculation totals into one, from the same table. With that said, I’m trying to determine the “Overall Need”, contract ...
I was able to resolve the issue with the following
Shaurya
Memorable Member
Memorable MemberHi CZMIU_cvazquez,
I see that you have created measures for these operations but you need these calculations done on a row level. Your measures are aggregating the numbers first and then doing the subtraction and multiplication. I suggest that you use these formulas to create a Calculated Column. That should give you the right numbers.
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical Comparison