3 Replies Latest reply on Feb 10, 2013 10:45 AM by Shawn Wallwork

    Sum of duplicate entries as single entity

    Gowtham P

      Hi,

       

      I am having a billing database. Each billing has multiple Order ids. The amount for each order is same. When we consider the billing amount for a Billing Id, we should consider the amount as only once.

       

      The data for each product looks like this.

       

      ProductBilling IdOrderAmount
      P1B1O115


      O215

      B2O120


      O220


      O320

       

      Here I want to display the total value of product for example P1 as  Sum of ( Min of (all orders) ) for each billing. So the total amount is 35.

       

      I tried many ways, I couldnt solve it. Any help is very helpfu.

       

      Best Regards

      Gowtham