Forum Discussion
Need Grand Total differently
Below is the logic of column E. In Total where it is highlighted as red (E column) we want vertical sum of column E 305 highlighted in green color. Similarly for column H we want vertical sum ...
sjoshi
Can you try :
E column logic Quantity =
SUMX(
'Inventory Discrepancy F',
abs(sum('Inventory Discrepancy F'[carrier QTY])-sum('Inventory Discrepancy F'[ERP Qty]))
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂