Displaying Credits correctly
I have a staging table with 2 relevant fields: Description and Amount.
Description is a text field and Amount is a number field.
These records are pulled from different tables.
Description will either say whether the amount is a credit or a debit.
The problem is the amount field is displayed the same way for debits and credits. When running a running total to calculate one final amount it is adding all the amounts. I need the running total to add the debits and subtract the credits.
I want to display the credits with a - before the number for example -330 and the running total should know to subtract this amount.
What is the best way to achieve this?