Forum Discussion
Total sum/multiply working incorectly
The reason you are getting this inconsistency is because the measure is grouping at the total level as sum. There are two approaches you can try, one is to create a calculated columng for ExtCost = PurNavLoc[QtyOh.] * PurNavCost[CostPrice]. This will add up your extended cost at the total level correctly, since it will sum all of the single ext costs per line.
The other one can be to create an ExtCost measure, as SUMX(Part[Part],PurNavLoc[QtyOh.],PurNavCost[CostPrice]), it will sum the multiplication of PurNavLoc[QtyOh.] and PurNavCost[CostPrice]
Let me know if it works
Alejandro
The reason you are getting this inconsistency is because the measure is grouping at the total level as sum. There are two approaches you can try, one is to create a calculated columng for ExtCost = PurNavLoc[QtyOh.] * PurNavCost[CostPrice]. This will add up your extended cost at the total level correctly, since it will sum all of the single ext costs per line.
The other one can be to create an ExtCost measure, as SUMX(Part[Part],PurNavLoc[QtyOh.],PurNavCost[CostPrice]), it will sum the multiplication of PurNavLoc[QtyOh.] and PurNavCost[CostPrice]
Let me know if it works
Alejandro
hi,
it was a bit more complex in my casebut in general sumx solved the problem! Thanks
sumx ( TABLE ; expression ) :)
