1 Reply Latest reply on Jan 5, 2012 6:04 AM by RichardWilliams

    Sum of Values from a Field



      Sum of Values from a Field




      I am building a database for which it is possible to have multiple payments for a single job (deposit, Final payment) I have created a payment database and a job database, so when you make a payment it is recorded against that job, what I would now like to do is add all the payments for that job together and show them in a new field ie total payments.


      It would also be good to be able to show in another field payment amount remaining ie Total cost - payments made 


      not quite sure where to start with this.  currently I have all the payments made for a particular job showing up in the portal against that particular job see image


      Thanks for any help