AnsweredAssumed Answered

Balance of each customer

Question asked by ntf on Feb 12, 2019
Latest reply on Feb 14, 2019 by beverly

Hello all!

I have a table with records of customers invoice amounts.

I want a field that shows in each row of table view the balance of all invoices for each customer. When I add a record with new invoice this balance field will be changed


Name               Invoice No     Amount          Balance

Customer A    Invoice 1          100               250

Customer A    Invoice 2          150               250

Customer B    Invoice 3          300               450

Customer B    Invoice 4          100               450

Customer B    Invoice 5            50               450


I tried with summary field with no luck so far...

Any help?

Thank you!