4 Replies Latest reply: Jul 1, 2009 7:41 PM by jalmeida RSS

    calculation of Date & quantity in diff rows (availability)


      Here's a tough case:

      How do you calculate the stock available after a sale by using two tables - one for the
      sales and another for the deliveries?
      I ran into the following problem: as I join the two tables of the sales and the

      deliveries together, for each sale I have to get the delivered quantity for the period before the sale (Date>SupplyDate) and calculate the remaining quantity. I can't figure out how to make this work. Any ideas?

      For example look at the file attached...