Refrasing question. I have both 'debit' and 'credit' sitting in same field.

I want to show debits in one column and credits in one colum,

and formula 'balance' (debit-credit) as another column.

 

Debit    - Credit   - Balance <titles.

10,000- (9,000)  1,000 <data

 

 

Thank you

 

***********

I have a table, User enters data, as invoice_amount, and he pays it partial (invoice_paid),  and I want to show this next to each other, as well I want to create a formula balance (Invoice_amount - Invoice_paid). On the reports, I want to show all these three columns as, invoice_amount, invoice_paid, balance (like three columns). Can somebody help me please how to do this.