Forum Discussion

DanPark1's avatar
DanPark1
Qrew Cadet
7 years ago

How to find the difference between column totals from two different tables/reports

I have 3 tables. Table 1 is Customers Table 2 is Deposits Table 3 is Deductions Relationship 1 is Customers have Many Deposits Relationship 2 is Customers have Many Deductions At the botto...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
no problem,

If you edit the relationship between Customers and Deposits, there will be a button to make a summary field, so make a summary of the Total Deposits.

Ditto for the Deductions table.,

Now you have two clean fields on your customer record and make a new formula numeric field to calculate the difference.