1 Reply Latest reply on Oct 27, 2016 3:04 AM by Norbert Maijoor

    How to get aggregate sum of a field that is repeated in multiple rows?

    saijyothi bandagi

      Hima vardhan Reddy Pavuluri

       

      Hi, Attached is the data set that I am working on.

       

      I need to get the Total of Bill Amount PER Delivered Date. The result that I am getting is much higher than the required value because the bill amount is repeated in multiple rows for the same order ID. Can you please help with any function that can solve this?

       

       

      Thanks!