4 Replies Latest reply: Jul 1, 2010 11:24 AM by Christo Roder RSS

    How to show correct value

      Hi guys. I came upon this problem and do not know how to solve this. Basically I have the following data:

       

      ItemAmountVolumes
      F1111300
      F2222200
      S333310,000.00500
      F5555100
      F6666400
      S444410,000.00500
      20,000.00 2,000.00


      This is a basic setup of an invoice. We sell 2 finished products (starting with F) as one set (starting with S). The system we are using allocates a sales amount to the SET which is correct. Thus we can sum(amount) an we will get total sales. The problem comes in with Volumes. If I sum(Volumes) I get double the number of volumes sold. How can I filter this so that it only shows the volumes of the SETS.

      Thanks in advance.