AnsweredAssumed Answered

summation / lookup script

Question asked by giddyup on Nov 13, 2018
Latest reply on Nov 16, 2018 by giddyup

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.


Included fields:

box number

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.