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



      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!