Forum Discussion

sjoshi's avatar
sjoshi
Icon for Helper II rankHelper II
5 years ago

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 ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

sjoshi , Try like

E column logic Quantity = sumx(summarize('Inventory Discrepancy F', 'Inventory Discrepancy F' [Item_id], 'Inventory Discrepancy F'[warehouse] , "_1",abs(sum('Inventory Discrepancy F'[carrier QTY])-sum('Inventory Discrepancy F'[ERP Qty]))),[_1])