Completing the form on RegData

This form is used to collect information about the lending we undertake and the fees we charge.

We complete only row 8: Lending-Other lending

The fee is 'Combination'

Total revenue = Loan arrangement fees + ISA account management fees + margin fees.

Total customers = Number of borrowers (on amortising loans) + Number of lenders on ISA loans who paid a fee. 

Total transactions = Count of number of records for Loan arrangement fees + ISA account management fees + margin fees.

An SQL has been created: https://projects.rebsoc.com/issues/34989

In Row 12, the total fees = total revenue.