AnsweredAssumed Answered

Sorted calculation

Question asked by jimmyfix on Oct 19, 2010
Latest reply on Oct 20, 2010 by jimmyfix

Title

Sorted calculation

Post

In order to keep this short I won't go into all that I am trying to do.

I would like to create calculation fields that will summarize all of the debits and credits for a particular account number without having to display it all in a layout. What I want in a single line is... account -> total debits -> total credits. So the calculation has to add up all the values of debits, for example, where the account is a certain value. I want this to be for all records, which after a number of years could be quite a few, but I don't want to have a big long list of the records just to get this value.

 

Example:

Acct=1100  total debits= whatever  total credits= whatever

Acct=1200 etc etc etc.

Does this make sense?

Thanks in advance for any help. I am trying to help a friend have an accounting solution that is just like a program he used to use. He is old and doesn't want to learn something new.

Outcomes