emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Question Regarding Creating Workflow For Automatic Formulas For Fina


From: Eric S Fraga
Subject: Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet
Date: Sun, 16 Jan 2022 18:10:31 +0000
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux)

On Sunday, 16 Jan 2022 at 10:35, Samuel Banya wrote:
>     How would you able to keep the running totals in Column E?

Using your initial example, adding a header line to give a starting
point, the following works:

| Date       | Item                    |   |    Debit |          |
|------------+-------------------------+---+----------+----------|
| 01/03/2022 | Example Rent Expense    |   | -1061.67 | -1061.67 |
| 01/04/2022 | Example Food Expense    |   | -1061.67 | -2123.34 |
|------------+-------------------------+---+----------+----------|
| 02/05/2022 | Example Utility Expense |   | -2061.67 | -4185.01 |
| 02/06/2022 | Example Random Expense  |   | -2061.67 | -6246.68 |
|------------+-------------------------+---+----------+----------|
#+TBLFM: $5=@-1+$-1;NE

I've not included monthly sums as this would complicate things (although
should still be possible...) but retain a dividing line for clarity.

The top entry of the last column could have a starting balance, if you
wanted.  At the moment, it's treated as a 0.00 value.

-- 
: Eric S Fraga, with org release_9.5.2-306-g9623da in Emacs 29.0.50



reply via email to

[Prev in Thread] Current Thread [Next in Thread]