Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Show total of matching records from related table


Recommended Posts

I have a database for tracking budgets, amount spent, and balance. I have a layout that I show information about each account. I want to have a field that will total all amounts written out of that specific account. How can I show that amount in a specific field. For example I have an account for the warehouse supplies. I want to have a field that shows a total of all the purchase orders that was written out of warehouse supplies.

Link to comment
Share on other sites


Purchases table must have account number and amount.

Create relation from Accounts table to Purchases table by account number.

Then use Sum(Purchases::Amount) function.

This is not exactly answer, because i dont now definitions of your tables and fields in the tables.

Link to comment
Share on other sites

  • Create New...

Important Information

Terms of Use