4 Replies Latest reply: Oct 30, 2015 6:44 AM by Martin Pohl RSS

    Calculating / expression

    KENNETH ANDERSEN

      I have data file looking like this:

       

      udklip.jpg

       

      There are 4 different SalesID (250 - 450 - 100 - 800). Now I like to calculate how many pieces of product AA10 has SalesID 250 sold but deducted all the products which has been resold.

       

      EG.:

       

      'SalesID 250' has sold 10 items of AA10 to 'BuyerID 450' - but 'BuyerID 450' has resold  2 items of AA10 to 'BuyerID 900':

      The calculate figure should be 8 (10 - 2)

       

      and

       

      'SalesID 250' has sold 5 items of AA10 to 'BuyerID 300' - and 'BuyerID 300' hasn't resold any items of AA10

      The calculate figure should be 5 (5 - 0)


       

      Any suggestions how to calculate this ?


      BR,

      Kenneth