1 Reply Latest reply on Feb 14, 2018 12:22 AM by Norbert Maijoor

    Fixed sum based on distinct IDs

    Ahmed Mukhtar

      I have 2 columns, items (Items_ID) and the sale price

       

      I want the count of unique ID (have duplications) so I simply did countD(Items_id)

       

      I cant do the same. I need for each UNIQUE Items_ID, sum of the sales price

       

      How can I do unique sum?

       

      I tried

       

      {Fixed countd(Items_ID): sum(Saleprice)}

       

      but it gives cant mix aggregate and non aggregate error.

       

      What can i do?

       

      any help please??