1 Reply Latest reply on Sep 1, 2014 7:04 AM by philmodjunk

    Displaying Credits correctly

    jakes

      Title

      Displaying Credits correctly

      Post

      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?