Hi Jinny,

Are you trying to calculate the Actual cost for all items or Avg.Unit Value?

If you are calculating the Actual cost, you are on the right track. Calculate the sum of the Total Cost 1 to Total Cost 5.

If you are calculating the average cost per item, you will want to divide the sum of the 5 Total Cost fields by the sum of the 5 Quantity on Hand fields.