8 Replies Latest reply: May 9, 2018 6:14 AM by Sasidhar Parupudi RSS

    Distinct in set analysis

    Wanyun Yang

      I have some Orders and Amounts with duplicates:

       

      Order Amount

      A         1

      A         1

      B         2

      C         1

       

      I'm trying to write a function to calculate SUM(Amount) for different Orders. The result should be: 1+2+1=4. How should I do it in set analysis?

       

      Thanks for help!