Let's say I have 1000 boxes of widgets. I need to generate a report that shows the box number, TOTAL value and cost for each box.
quantity per box
extended price per item (quantity x price)
extended cost (quantity x cost)
I am not a script person, but I assume it requires a lookup and some sort of "sum" calculation. I am hitting the wall on how to find all the boxes and run the calculations on each one.
Any thoughts? Thanks in advance.