Skip to Content
Nov 17, 2016 at 01:39 PM

Sum calculations in Bex


We have a scenario in which we need to sum up the sales quantity for a particular material, date then to use this sum in all sales order line items:

for example: Material: ABC; Date: 01.11.2016

Sales Order Material Qty Sum(Qty) on 01.11.2016

1001 ABC 10 30

1002 ABC 10 30

1003 ABC 10 30

My question here would be how we can calculate the sum of quantity for material, date combination and to display the same at each line item

Thanks in advance.