Forum Discussion
Wrong total values
Dear Community, have the following table below and receive the wrong column values. hope someone can help to fix that calculation. DATE YEAR = Time Table DATE Month = Time Table DATA 1 = DA...
Ah. OK. Is it something like [Quantity] x [Price]? If so, you need to calculate that at the individual LINE level, the create a measure to aggregate the sum.
You cannot aggregate the individula columns first and then do the multiplication or division.
5 pieces x $10 each = $50
10 pieces x $20 each = $200
From this you cannot say:
Total of 15 pieces x total of $30 each = $450.
You have to do the SUM of $50 + $200 = $250
Correct! Line would be -5 (Data 5) x 500 (Data 1) --> Result = Data 6 --> -2500
Aggregate should be Data 6 --> -8400 but right now i get -11900
How would that measure to aggregate the sum look like ?