3 Replies Latest reply: Apr 11, 2018 6:22 AM by willem van der Plas RSS

    different granularity

    willem van der Plas

      HI all,

       

      i have a problem. I need to sum the total reveneu of an invoice but it consists of 2 components:


      1. goods amount

             

      invoice numberreveneuproduct_ID
      15478 €    40,00 TAT
      15478 €    20,55 PTH
      15478 €    79,10 JFD
      15478 €    88,50 FFT

       

      2. transport

       

      invoice numbertransport costs
      15478

      120

       

      If i do an applymap with the invoice nummers als map_ID it will add transport to all the rows containing the same invoice number. How can i add the transport turnover once per invoice?

       

      thank you in advance!