Forum Discussion

jeeviscarozza's avatar
jeeviscarozza
Regular Visitor
3 years ago

Running Total by Lot Number

Hi! I am trying to get a running total of our items we have in stock for each item, by adding up the quantity of each consecutive lot. Each item has multiple lots. The product lot number column indi...
Need Help
jeeviscarozza's avatar
jeeviscarozza
Regular Visitor
3 years ago

Here you go

Lot Expiration DateProduct lot numberQtyLot Expiration DateProduct item numberIntended Output
30-Nov-241341201841030-Nov-24134110
30-Nov-241341201641030-Nov-24134120
30-Nov-241341201621030-Nov-24134130
30-Nov-241341201651030-Nov-24134140
30-Nov-241341201661030-Nov-24134150
30-Nov-241341201671030-Nov-24134160
30-Nov-2413412017310030-Nov-241341160
30-Nov-241341201831030-Nov-241341170
30-Nov-241341201631030-Nov-241341180
30-Nov-241341201851030-Nov-241341190