AnsweredAssumed Answered

Displaying Credits correctly

Question asked by jakes on Sep 1, 2014
Latest reply on Sep 1, 2014 by philmodjunk


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?