1 Reply Latest reply: Jun 26, 2018 12:58 PM by Sunny Talwar RSS

    Calculating Total According to Unique Key

    Atilla Olgum

      Hi All,

       

      I need help with creating an expression to sum values for a given field with the ability to filter according to a distinct key value to avoid double counting.

       

      For example

       

      KeySale
      Key1500
      Key1500
      Key21000
      Key21000
      Key31500
      Key31500
      Key3

      1500

       

      I want to calculate distinct Key1 + Key2 + Key3 and arrive at 3000 as the total instead of 7500.

       

      Your help will be greatly appreciated

       

      p.s. if you're wondering the kind of data set that has this set-up, it is list of flights transporting cargo under a unique contractual agreement, where the contractual agreement is the Master Air Waybill.