Calculating fields

[apples]

I have a situation where I have 2 value fields a debit field and a credit field. The Credit field has some values that display a - (negative) and some that dont.
However I am trying to sum each of these fields individually in a report.Then substracting the result from each other. The problem is that the - values that appear in the credit field should be added and not substracted from sum total.
The question is what formula do I use to ensure that all the values in the credit field are negatives.
thanks
Sonia

 

[dgillz]

First, I would highly question your premise. I have seen accounting software that lets you have a Negative debit or a Positive credit.

However, if you are convinced that this is what you what to do, create a formula field and use the absolute value function.

abs({Creditfield})

Then sum both this field and the debit field and then subtract the two sums in another formula field. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[apples]

Hi there,
Thanks it worked.
Unfortunately the Global in house accounting software that I am dealing with leaves much to be desired. I have user input errors to deal with among others. I have to extensively check my results in access / excel before approving the results of the report. Really a mission! but I will call it "challenging".

 

[dgillz]

Apples - what software is it you are using? I do quite a bit with accounting software and crystal. Please advise. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office