1 Reply Latest reply on Jan 19, 2015 11:16 AM by KK Molugu

    How to sum the amount of unique account?

    carine.ye

      I have a table like this:

       

      ID                   Amount                Marketing

      1                     100                       10

      1                     100                        20

      1                     100                        5

      1                     100                        1

      2                      200                       5

      2                      200                       9

      2                      200                        7

      2                      200                        5

      2                      200                       10

      2                      200                        21

      3                      300                        9

      3                      300                        8

      3                      300                        9

       

      The relationship of ID to Amount is 1 to 1. But after jointing two tables, one ID has four amount.

       

      How can I sum the amount for unique ID? The result should be 100+200+300=600

       

      Thanks!