2 Replies Latest reply: Mar 8, 2018 7:44 AM by max payne RSS

    ignore duplicate records

    Christina mueller

      Hello,

      I have a table, that looks like this:

       

      Number      total costs
      123456200
      123456200
      123456200
      654321400
      654321400
      654321400
      765432200
      234567300
      234567300

       

      Now I wanna make a sum() over all the costs but with every "total cost" of every "number" only once.

      So the sum() should be 1.100 and not 2.600?? Is there a function for this?

       

      Thank you in advance

      Tina