| View previous topic :: View next topic |
| Author |
Message |
PegM_4
General User
Joined: 28 Oct 2007
Posts: 33
|
 Posted: Thu Sep 29, 2011 4:01 am Post subject: SOLVED: make every entry negative |
 |
|
Can I create a column that will make every entry in it a negative without a - in front of the number?
I'm trying to create my own check registry and would like to have every entry in the "Credit" column be negative without my typing in the - in front of the number. Is this even possible?
Thanks
Peg
Last edited by PegM_4 on Sat Oct 01, 2011 7:07 am; edited 1 time in total |
|
| Back to top |
|
 |
mgroenescheij
Super User
Joined: 20 Apr 2011
Posts: 862
Location: Australia
|
| Posted: Thu Sep 29, 2011 4:53 am Post subject: |
|
|
Hi,
If you have a Debit and Credit Column all numbers should be positive.
When you do calculations you make sure that you subtract Credits.
So your Closing Balance should be Opening Balance+SUM(Debit)-SUM(Credits)
Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
PegM_4
General User
Joined: 28 Oct 2007
Posts: 33
|
| Posted: Thu Sep 29, 2011 5:34 am Post subject: |
|
|
| mgroenescheij wrote: | Hi,
If you have a Debit and Credit Column all numbers should be positive.
When you do calculations you make sure that you subtract Credits.
So your Closing Balance should be Opening Balance+SUM(Debit)-SUM(Credits)
Martin |
Ahh...That makes sense. Thank you.
Peg |
|
| Back to top |
|
|
|
