I am using Airtables to hold a table of my customers and their credit limits etc and keep a tally of invoices sent and their payment status.

I was wondering…
Next to where the customers credit limit is, I would like a column that shows their current credit usage.

IE.
IF invoices table,column.invoicespaid = no then sum amount where invoices table,column.cutmoner name = thistable.accountname

Is this possible?

Hopefully you understand my attempt at an example formula