3 Replies Latest reply on Jun 24, 2013 8:31 AM by brett_

    How to sum purchases?

    brett_

      Title

      How to sum purchases?

      Post

           I have Customer and 'Purchase Transaction' tables.  'Purchase Transaction' holds all the purchases a customer may have made.  When looking at customers, I'd like to see a total of their purchases.  

           I did create a calculation field in 'Purchase Transaction'.  It does a Sum( Purchase Price).  But all I see is the Purchase Price for the current row.  There is no summation of all purchases for that customer.  Any idea how this can be done?